#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel Query

I have an Excel query on a work sheet which imports my web page.
However, I've just republished my web page but the query still shows the old
page even though I've refreshed the query. The new web page is definitely
out there. What's going on? Help please.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel Query

OK it seems to have been solved....I ticked the remove external data before
saving and somehow that worked??! (even though I hadn't saved!)


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Excel Query

Hi Dennis,

It may be that the previous version of the web page is being retrieved from
the temporary internet cache and that periodic retrieval of the web page will
refresh the cache.

Anthony

"Dennis Saunders" wrote:

I have an Excel query on a work sheet which imports my web page.
However, I've just republished my web page but the query still shows the old
page even though I've refreshed the query. The new web page is definitely
out there. What's going on? Help please.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using A Cell In Excel as Criteria for a Query charles Excel Discussion (Misc queries) 2 July 14th 06 05:06 PM
Excel 2000 using Web Query is slow on Excel 97 [email protected] Excel Discussion (Misc queries) 0 April 10th 06 06:10 PM
enable automatic refresh Vass Excel Worksheet Functions 2 March 11th 06 04:36 AM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
Micosoft Query does not export result set to excel Peter McAuley Excel Worksheet Functions 0 June 16th 05 08:53 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"