JanetStackpole
Programmer
I found the above thread..and am having the same problem.
I have two xls workbooks, 2003 version, located on a file server.
1. A source xls workbook that refreshes data from SQL Server into a pivot table.
2. A workbook that is used to import the data from the pivot table from the 1st workbook. (data -> import external data -> import data...)
When refreshing the 2nd workbook, I get one of the following results:
On some machines it refreshes and displays all of the data.
On other machines it refreshes without errors, but only displays a one column of data.
In both instances they are accessing the same xls workbook.
I am stumped.. Any assistance would be greatly appreciated.
I have two xls workbooks, 2003 version, located on a file server.
1. A source xls workbook that refreshes data from SQL Server into a pivot table.
2. A workbook that is used to import the data from the pivot table from the 1st workbook. (data -> import external data -> import data...)
When refreshing the 2nd workbook, I get one of the following results:
On some machines it refreshes and displays all of the data.
On other machines it refreshes without errors, but only displays a one column of data.
In both instances they are accessing the same xls workbook.
I am stumped.. Any assistance would be greatly appreciated.