<div>
That doesn't make sense!<br />
<br />
That method refreshes all external data ranges and PivotTable reports in the specified workbook.<br />
<br />
Check if the values are not changing from another macro.<br />
<br />
You just want to refresh the pivot tables?
</div>


That doesn't make sense!

That method refreshes all external data ranges and PivotTable reports in the specified workbook.

Check if the values are not changing from another macro.

You just want to refresh the pivot tables?

<div>
I have no links to other workbooks that I can see and no other macros in my spreadsheet.<br />
This is the most bizzare thing I have ever seen
</div>


I have no links to other workbooks that I can see and no other macros in my spreadsheet.
This is the most bizzare thing I have ever seen

<div>
Not sure if it was your answer or not. Closed Excel, re-booted PC input your sub, ran without error.<br />
<br />
Thanks
</div>


Not sure if it was your answer or not. Closed Excel, re-booted PC input your sub, ran without error.

Thanks

<div>
<div class="content wysiwyg-content">
Does anybody know why ThisWorkbook.RefreshAll is not only refreshing all of the pivots in my workbook but also removing formula that I have in the underlying data.<br />
<br />
i.e. formula in cell is =TODAY() which is displayed as 03/01/2013<br />
<br />
after running macro with ThisWorkbook.RefreshAll cell changes to 27/12/2012<br />
<br />
formula in next cell is =H2 which displays 11<br />
<br />
after running macro with ThisWorkbook.RefreshAll cell changes to 4<br />
<br />
thank you
</div>
</div>


Does anybody know why ThisWorkbook.RefreshAll is not only refreshing all of the pivots in my workbook but also removing formula that I have in the underlying data.

i.e. formula in cell is =TODAY() which is displayed as 03/01/2013

after running macro with ThisWorkbook.RefreshAll cell changes to 27/12/2012

formula in next cell is =H2 which displays 11

after running macro with ThisWorkbook.RefreshAll cell changes to 4

thank you

ThisWorkbook.RefreshAll

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.