<div>
What happens if you record a macro while doing it manually, undoing the change and then running the macro?
</div>


What happens if you record a macro while doing it manually, undoing the change and then running the macro?

<div>
I tried that and nothing was recorded.<br />
I'm &quot;thinking&quot; this will work?<br />
<br />
Sub UpdatePivot()<br />
<br />
SendKeys &quot;%{F5}&quot;<br />
<br />
End sub
</div>


I tried that and nothing was recorded.
I'm "thinking" this will work?

Sub UpdatePivot()

SendKeys "%{F5}"

End sub

<div>
Sure but (and I don't know much about pivot tables) would you need to add code to select the table?
</div>


Sure but (and I don't know much about pivot tables) would you need to add code to select the table?

<div>
All the user has to do is click on the pivot table. I don't know how to select a pivot table vba, yet!?
</div>


All the user has to do is click on the pivot table. I don't know how to select a pivot table vba, yet!?

<div>
I can select a pivot table using vba - but the pivot table name would have to remain static and I'm not sure how that's going to hold up?
</div>


I can select a pivot table using vba - but the pivot table name would have to remain static and I'm not sure how that's going to hold up?

<div>
thanks Martin<br />
Have a Happy Thanksgiving
</div>


<div>
<div class="content wysiwyg-content">
Folks,<br />
I know of several ways to refresh data in a pivot table. The one I am interested in doing is a macro using SendKeys, &quot;Alt + F5&quot;. Possible?
</div>
</div>


Folks,
I know of several ways to refresh data in a pivot table. The one I am interested in doing is a macro using SendKeys, "Alt + F5". Possible?

Macro using SendKeys

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.