Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello everybody, one of my kolle

Status
Not open for further replies.

StephanieD

IS-IT--Management
Jan 28, 2002
22
DE
Hello everybody,

one of my kollegues has a problem with an Excel-Workbook. The Datasheets contain quaterly information. As far as I am informed the data is comming from an Access Database and is included on refresh request in a Pivot Table. When the Pivot Table is selected and the User wants to refresh the data he is getting the error message:

Pivot Table was changed during Refresh Data operation.

He clicks ok, the error message comes again. He clicks ok again and then this error message appers:

The Program has performed an illegal operation and will be shut down.

The data is on a network drive but not moved within a year. The user has a Windows 98 PC. When I call the Excel-Sheet I can refresh the data without any problems with my Windows 2000 PC. Network entries (TCP/IP Properties) are correct.

Thanks for your assistance.

Stephanie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top