We have an old Excel97 solution with a .xls-File including two sheets "A" and
"B" where sheet A has a lot of references to sheet B, like "=B!K2". Due to
some circumstances we can't simply switch over to newer Excel versions.

Someone seems to have checked and maybe saved the xls file using a newer
Excel version or a Open Office version and now each time we want to save the
file we get a message box "This file was created using a later version..."

Because we found no way to suppress this annoying message box I tried to copy
the two sheets into a newly created Excel97 table and here comes the problem:

If I open both files in the same Exvel97 window I can drag and drop both
sheets from one file into the other including formats and formulas, but the
formulas in sheet A of the NEW table still refer to sheet B in the OLD file
like ="D:\oldpath\[oldfile.xls]B'!K2

If I open two instances of Excel97 I can copy the sheets via clipboard but
without formulas.

So how can I copy the sheets while maintaining the RELATIVE reference to
sheet B only?

Or alternatively, how can I change all references to sheet B of the old table
into references to sheet B of the activ file for many cells in one step?
There are too many cells to edit the formulas manually cell by cell.

Of course, the simply way would be ti suppress the message box, then I
wouldn't have to copy anything, if possible.

Is there still an Excel97 professional out here who can help me?

Thanks, wuez.

Did you already try deleting 'External References'?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion