Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 external data source extend table refresh
Hello,
I insert data from an external data source into a worksheet. I add some data to the first column to the right of this table, with some manually entered data. The table automatically extends to include the new column. When I click on the refresh data button, all is well. Then I sort on one of the columns in the table. Now any time I click on the refresh button, the column that was not part of the original table, i.e. not part of the external data source, gets scrambled randomly. The rows bounce around every time I click on the refresh button. Can anyone tell me what I'm doing wrong or how I go about getting the manually entered data to stay on the same row that it was entered on? -- Gary Niemi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
How do I refresh Pivot Table from an external source ? | Excel Worksheet Functions | |||
Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) |