Pivot Table

[Guest]

I have a Excel book that works Ok in Office 97 with the pivot tables.
When I open it in Office 2003 it opens a new sheet whih this text:

"Because of restrictions within Microsoft Excel,the following items from the
worksheet Sheet 1 might contain inaccurate results in the Excel PivotTable:
GP %
To see accurate results for these items, view the items in the Static Data
Sheet"

And the pivot table didn't open.

Anybody nows the problem.

Thanks
Xavier.

 

[Debra Dalgleish]

What kind of information was in the GP% field? Was it calculated, or
from the source data?

 

[Guest]

Is calculated automaticaly I delete it and It reapears

"Debra Dalgleish" escribió:

 

[Debra Dalgleish]

Is there a field on the static data sheet, with the heading GP%?
If so, what kind of data do you see in that column?

 

[Guest]

Yes there is. The data is the same in all of the line (is the name of the
salesman)
I delete all of the column and the GP% reapears every time in dome part of
the sheet.

"Debra Dalgleish" escribió:

 

[Debra Dalgleish]

Is there a macro that runs when the workbook opens? Normally, a column
doesn't reappear if you delete it.

 

[Guest]

Yes, but is impossible to see it because the workbook is external (it's made
in another computer) Today i try to open it in an Office 2000 runing Windows
98 computer and all works Ok.
I don't understand it.

"Debra Dalgleish" escribió:

 

[Debra Dalgleish]

I haven't seen that message before, but some statistical functions were
changed in Excel 2003:

Description of improvements in the statistical functions in Excel
2003 and in Excel 2004 for Mac
http://support.microsoft.com/default.aspx?scid=828888

Excel Statistical Functions: VAR and VARP improvements and pivot tables
http://support.microsoft.com/default.aspx?scid=829250

Maybe that's causing the message to appear. You could create a new pivot
table in Excel 2003, from the original data.