Posted to microsoft.public.excel.misc

Kim

external usenet poster

Posts: 284

Macro for auto refresh

Is there a macro where I change a cell in one sheet and the pivot table will
auto refresh.

If I change the cell B18 in Dashboard sheet, the pivot table in City sheet
will refresh automatically.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Excel functions formula and auto refresh refresh	Pauline Cheong	Excel Worksheet Functions	3	February 16th 09 01:23 AM
How can I auto refresh a column that has an auto filter in place	Pastal	Excel Discussion (Misc queries)	1	December 18th 07 11:43 AM
Running a macro from an auto-refresh	Chris Youlden	Excel Worksheet Functions	2	October 7th 07 04:22 PM
auto refresh	Lou Sanderson	Excel Discussion (Misc queries)	2	August 17th 06 05:45 PM
How can I auto-refresh auto-filters when data changes?	Mike@MPWco	Excel Worksheet Functions	0	July 4th 06 12:50 PM

All times are GMT +1. The time now is 05:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us