Pivot Table - Compatibility Mode Message

[jim may]

I run xl2007 ONLY in my office. A client needed some additional work done on a file (with Macros) created solely in xl2003 (abc.xls). They e-mailed me the file and I performed the changes. The file when opened by me (in xl2007) read Compatibility Mode in the FileName header all the time I was working with it.
When I saved the file (as File type Excel 2003 wb) - (r-abc-xls) the compatibility-checker came up indicating:
The PT in this wb is built in the current file format and will not work in earlier versions of Excel. Only PT's that are created in Compatibility Mode will work in earlier versions of Excel.
I clicked "Continue" and Saved as .xls (2003 file type).

At the office, they loaded "r-abc-xls" and ran the single macro (invovling the only PT) and they got a R/T 1004 message:

This PT was created in a later version of Excel and cannot be updated in this version. To update it, click OK and then open the wb in the version of Excel it was originally created in. grrrr

Any clues as to the direction to go?

Thanks in advance,

Jim

 

[jim may]

While updating .xls file in 2003 compatibility mode, obviously I had to use the xl2007 commands, buttons, etc. I don't remember doing anything that seemed xl2007 specific, but if I did - that is my obvious problem.

The final solution might only come with going to the clients office and SOLELY on xl2003 - reentering all the changes.. I hate to think I'd have to do that.,, but...

On my office PC (Excel 2007) - yes, I have SP 2 installed;

I should check with my Client whether they have the latest SP's for 2003, right?

Tks,

Jim

 

[RoryA]

Wouldn't hurt to check, though I suspect any error must be happening in 2007.