Posted to microsoft.public.excel.misc

external usenet poster

Posts: 414

External Data Refresh all just for one worksheet

I have a worksheet with multiple external queries linked to Access. I want a
user to be able to refresh all external data, but just within this one
spreadsheet and not across the whole file.

Is there any VBA that I can put behind a button just to refresh all queries
within this one worksheet?

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
Automatic refresh of external data	Rick	Excel Worksheet Functions	1	May 26th 08 06:41 PM
Create refresh button in worksheet to refresh Pivot Table Data	Ron	Excel Worksheet Functions	1	October 13th 07 01:20 AM
External data refresh	Texas Tonie[_2_]	Excel Discussion (Misc queries)	1	April 17th 07 11:02 AM
external data refresh	shoreguy	Excel Discussion (Misc queries)	0	March 7th 06 06:30 PM
External Data Refresh not working	Mike B in VT	Excel Discussion (Misc queries)	0	February 10th 06 06:23 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us