Pivot tables

  • Thread starter Thread starter Bill Ridgeway
  • Start date Start date
B

Bill Ridgeway

I temporarily saved my Excel97 file as another name (in csv not xls
format)and the Pivot tables (in another file) are now looking to the
'temporary' file name.

Is there any way of persuading the Pivot tables to look at the correct file?
Edit Links doesn't seem to want to work. This would save having to re-make
the Pivot tables

Regards.

Bill Ridgeway
 
Untested:

Copy your xls file to a nice safe location--just in case!

Open your data xls file.

Do File|SaveAs, choose .csv and save it to the same location that the pivottable
..xls file is pointing to.

Keep the .csv file open and open the pivottable workbook.

Save the .csv file to its rightful home as a real .xls file.

I'm hoping that the pt .xls file will see the change and remember it. Save and
close the pt .xls file and test it out.
 
Back
Top