Copying data and derived graph & pivot table (Excel 97/all)

Topic

New Reply

Hello,
can anyone save me out of this one? It could spare me a lot of time…
I’m trying to recover a huge corrupt Excelfile by copying-pasting all content to a new file . However, the references of the coupled pivot tables & graphs keep pointing at the source data in the original file. Is there a way to copy them in such a way that they point at the same data-cells in the new file where they’re pasted in? Tab names and location of the data are made identical to those in the original file…
Hasse

Reply | Quote

Replies

Maybe this may help ( a bit)

My flexfind utility is able to do search and replace inside most of Excel’s objects. Maybe it can do the job?

Find it at my site below.

I doubt if it can S&R in the PT source data though, but who knows.

Reply | Quote

Maybe this may help ( a bit)

My flexfind utility is able to do search and replace inside most of Excel’s objects. Maybe it can do the job?

Find it at my site below.

I doubt if it can S&R in the PT source data though, but who knows.

Reply | Quote

After you copy the info and you have the 2 files identical. Edit the links and change the source to the new file name.
[Edit – links – change source (select current file)]

This should break all the links to the original.

Steve

Reply | Quote

After you copy the info and you have the 2 files identical. Edit the links and change the source to the new file name.
[Edit – links – change source (select current file)]

This should break all the links to the original.

Steve

Reply | Quote