Browse » Home
Thursday, July 14, 2011
How to Modify the Data Source in Excel 2007
1. Launch Excel 2007.
2. Click the 'Windows' button in the top-left corner. Scroll down an click 'Open' and then find the spreadsheet that you want to modify. Highlight the field or fields that you want to modify.
3. Click the 'Options' tab. Click the 'Change Data Source' button in the 'Data' group.
4. Click the radio button either next to 'Select a table or range' or 'use an external data source.' Type in the Table/Range' in the field or hit the 'Choose Connection' button and find the source that you want to link with your Excel file.
5. Click the 'OK' button.