Excel 2000 to Excel 2003

[Mike]

Hi:
A friend is sending me a spreadsheet with formulas and macros created in
Excel running on Windows 2000. I am running Windows XP with Excel 2003.
Whenever I try to open his file, I am get two pop ups asking whether or not
to disable macros. Regardles of how I answer, the spreadsheet eventually
opens, but EXCEL says that the file was corrup and that it had to repair the
file. The repaired file is non-functional because all the macros have been
scripted. If I send the file back to the originator, he says it works fine.

The file was sent to another person with Windows XP and EXCEL 2003 and he
has the same problem. I tried the file at home with Windows XP and EXCEL and
again the same problem.

Any ideas on how to fix this problem?
Thanks

 

[Dave Peterson]

I'd ask the originator send the original file once more.

If that didn't work, I'd ask that the file be zipped and then sent.

 

[Mike]

Hi Dave:
That didn't help we have zipped, CD, etc. The problem still persist. Any
ideas on what could be the problem. Also, I made a mistake in the name. The
problem is between EXCEL 97 on a Window 2000 machine and EXCEL 2003 on a XP
machine.
Thanks

 

[Dave Peterson]

Your copy of xl2003 should be able to open a file created with xl97 with no
problems.

My next guess is that the file is corrupted some how. But the only fix I know
for that is to recreate the workbook. And that's could be a big job.

 

[Mike]

Hi:
Yes, corruption seems to be the reason. My guess now is that the
orginator's computer system has some kind of low level conversion taking
place. Ie Linux to Intel, etc. Are you aware of any issues involving the
setup of each operating system to communicate with each other, ie. bitwise
swapping, etc.?

 

[Dave Peterson]

I don't know anything about that kind of stuff.

But both of you have to be running some kind of version of Windows, right?

Maybe you could ask him to create another workbook (just a test workbook) and
send it to you.

See if that works.

 

[Mike]

Thanks, will give that a try, but I think they are writing it off as
something they can't do, at least with this workbook.