Pivot Table

X

Xavier Antolin

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.
 
D

Debra Dalgleish

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

Xavier Antolin

Is calculated automaticaly I delete it and It reapears

"Debra Dalgleish" escribió:
 
D

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?
 
X

Xavier Antolin

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ó:
 
D

Debra Dalgleish

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

Xavier Antolin

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ó:
 
D

Debra Dalgleish

Top