I had a similar problem in XL97, which was never resolved :(

Have you tested without any passwords (on sheets or VBA)? I know
your final solution may require VBA protection, but that's my first
thought as to something to test.

Does the Bovey code cleaner work in XP? I'd try that, regardless.
:)

I'm not a heavy user of pivot tables, but are there any features
of XP pivot tables that were not available in 2000 that might
cause problems? If so, such problems might only be seen when
data is present, thereby "triggering" those features. It might be
worth taking a clean workbook and building one pivot table
(similar to the most complex one you have in your workbook,
in terms of data complexity, formatting, etc) to test in 2000.

If you just want your output, I'm not sure it would be that difficult
to copy each sheet, and it's print settings, unless you have a lot
of inserted page breaks. I always found hard page breaks to be
a problem in XL, so I quit using them altogether. Can you be more
descriptive about how many sheets/pages you have, or why you
forsee problems using that as a solution? I'm thinking along the
lines of (select sheet) copy/paste special, paste values. If
the formatting is critical, I sometimes paste first (which includes
formatting, but also the formulas, etc) then repaste on top of that
the paste special/values to get rid of the formulas. You could
always test a few of your more complex sheets first, then set
up VBA to just cycle through all sheets and transfer to a new
workbook.

HTH,
Keith

NJD wrote in article
. ..
I'm facing the most bizarre and frustrating bug that I've seen in 15
years of programming. I hope someone here can offer a solution.

<snip

Here are things I've tried that did not work.

I left the file as it is with all formulas and VBA code, but just locked
a few things -- hid some pages and disallowed viewing the VBA macros.
Still won't save, unless I clear out all the data and refresh the pivots
as I've been doing all along, but which defeats the purpose.

I've tried converting all formulas to values, deleting the pivot tables
in the reverse order I had created them and then deleting all hidden
pages. No luck. Still can't retrieve saved file.

I then tried adding a new workbook, moving the pages from the original
template so that the resulting file would contain no formulas, no hidden
pages and no VBA code. Same thing. It opens up fine in XP but will not
open in Excel 2000.

Obviously there is some kind of corruption that only becomes evident
when the model has data and is only a problem for older versions of
Excel. I've thought of trying to manually copy everything to a new
workbook to see if that solves it, but that would be a big job. There
are hundreds of range names, complex formulas, all kinds of charts,
print settings for each sheet, etc. I'm not even certain that would
work.

Anyone have any ideas? This is a rather serious matter.
People have been working on this project for months.

--
Nick Delonas