Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PREVENT EXCEL 2007 FROM REFRESHING FORMULAS THAT REFER TO OTHER WORKBO
- Thread starter debbiepy
- Start date
With Excel 2003 you can use Edit,Links BreakLink to convert those link formulae to values. I don't recall that option in Excel 2000.
Right Click on the pivottable and have a look at the table options. Make sure "Refresh on Open" is not ticked.
Think about whether you want the data to be saved with the table (increases spreadsheet size and enables recipient to drill down or select a different pagefield etc. Consider copying to values.
Not sure why calculation options would be greyed out.
Gavin
Right Click on the pivottable and have a look at the table options. Make sure "Refresh on Open" is not ticked.
Think about whether you want the data to be saved with the table (increases spreadsheet size and enables recipient to drill down or select a different pagefield etc. Consider copying to values.
Not sure why calculation options would be greyed out.
Gavin
- Status
Similar threads
- Locked
- Question