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.