Hello all,

I managed to copy all worksheets and chart sheets. However, the formulas are
referring to the source file (as I was warned). I would like to iterate all
cells and update the formulas for each (seems simple, I only need to change
the text of the formulas and replace "[old_source_file.xls]" with ""). Can
this be done?

Also, can I modify each embedded chart object on each worksheet and change
it to not refer to the old workbook file (in case the chart was using data
from a different sheet). Where is the chart's data/formulas kept? Can I
accees the formulas?

Best regards,
Levente


"macropod" wrote in message
...
Hi LF,

The way around this would be to create all the required worksheets in the
new workbook, with the same names as in the source workbook, then CUT (not
copy) & paste the source workbook's contents into the new workbook, after
which you close the source workbook without saving the changes.

Cheers

--
macropod
[MVP - Microsoft Word]


"LF" wrote in message
...
Ooops. How can I get this to be correct? I mean, cannot a formula be
incorrect for a while until I also copy over the rest of the sheets? Can
I
adjust the formulas after copying. Any solution?

"macropod" wrote in message
...
Hi LF,

I am not sure I understand. When you copy over from one worksheet to
another, don't you simply copy the formulas?

If you have a formula on Sheet1 that refers to Sheet2, for example, the
copied formula will point to Sheet2 in the original workbook, not
Sheet2
in
the copy.

Cheers

--
macropod
[MVP - Microsoft Word]