On open prompt to 'Refresh All'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 30 Sep 2005 11:20 GMT

Hi All,

I have a spreadsheet which has an external data range and then two
pivot tables feeding off of that worksheet page.

Is it possible that when the spreadsheet is opened it prompts the user
if they want to refresh all.

If they select Yes then this would refresh the external data and then
update the two pivot tables?

Many Thanks

Adam

Office 97

Reply to this Message

Dave Peterson - 30 Sep 2005 13:17 GMT

If you rightclick on the pivottable, you can choose "Table Options"

At the bottom of that dialog is an option to "refresh on open".

It sounds like it fits the bill.

> Hi All,
>
[quoted text clipped - 12 lines]
>
> Office 97

Signature

Dave Peterson

Reply to this Message

Adam - 30 Sep 2005 15:56 GMT

That won't work because the External data needs to update before the
pivot tables are updated.

Reply to this Message

Dave Peterson - 30 Sep 2005 21:21 GMT

Maybe a macro?

Option Explicit
Sub auto_open()
ThisWorkbook.RefreshAll
End Sub

> That won't work because the External data needs to update before the
> pivot tables are updated.

Signature

Dave Peterson

Reply to this Message