Excel 2000 using GETPIVOTDATA()

tswuensche

New Member
Joined
Oct 6, 2005
Messages
2
I have a pivot table outside the workbook containing the GETPIVOTDATA formula. When opening the workbook containing the formula, the values are -0- until the source workbook is entered. Is there a setting, etc. to have those values remain whether the source is open or not?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,388
Members
412,590
Latest member
Velly
Top