XL 2008 pivot table refresh

[synergy46]

I am running XL 2008 on a Mac and have created a pivot table that works well. However, without VBA (and I don't know how to write in Applescript), is there a way to put a REFRESH button on my spreadsheet?

 

[RoryA]

Can I ask why you need a button, when you can just right-click and refresh? (or use Data-Refresh data)

 

[synergy46]

Can I ask why you need a button, when you can just right-click and refresh? (or use Data-Refresh data)

Thanks for the reply.
I 'prefer' a button because this application is target to 'very unsophisticated' users who probably wouldn't think of the right click or the menu selection. But a button that says "Refresh" would certainly be easy enough.

Also, if I can attach some code to the button I can probably put it in a macro and have it fire on a 'change' event???

But, in any event, the button would do the job.

 

[RoryA]

As you've already noted, you can't use macros or events since they are VBA based. Are all your users on XL2008 too?

 

[synergy46]

As you've already noted, you can't use macros or events since they are VBA based. Are all your users on XL2008 too?

No, most users would be Windows based. Why do you ask?

 

[RoryA]

Because it's better to design for your target audience!
There's not much point coming up with an Applescript solution if 95% of your users can't use it - you might as well design a VBA solution for them (especially as it will be about 2 lines of code)?

 

[synergy46]

Because it's better to design for your target audience!
There's not much point coming up with an Applescript solution if 95% of your users can't use it - you might as well design a VBA solution for them (especially as it will be about 2 lines of code)?

Right you are! But, as you are probably well aware, Microsoft EJECTED VBA from XL2008 and XL2004 (which I have) produces LISTS which are incompatible with XL2007. What to do?

 

[RoryA]

You don't have to use Lists in 2004 and I thought we were talking about pivot tables?

 

[synergy46]

No lists? Hmmmm.... good point. I could just use dynamic ranges with autofilter... Well, I am going to push the limits of 2008 and see what I can and can not do. Looks like this is a 'can not' do item.

 

[synergy46]

BTW, are you familiar with a non-vba workaround to allow a LIST to function while the Worksheet is protected?