Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
KSP KSP is offline
external usenet poster
 
Posts: 2
Default Query Table Deleted on Refresh

Hi

I am running Excel 2003 with SP3 and have been having an ongoing issue with
excel deleting query tables when the external data is refreshed. There seems
to be no logic to when or why it happens - it appears to be purely random. It
is not isolated to just my PC but happens on other machines within the
company.

Does anyone know how to stop this from happening as it is really frustrating

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 360
Default Query Table Deleted on Refresh

Are you positive the table is gone? Look in your name drop-down to see
if the named range is still there. How do you refresh them?

Cliff Edwards

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
Code To Refresh Query Table Carl Excel Discussion (Misc queries) 0 December 8th 06 01:23 AM
refresh Query table using own password for each username kuh Excel Programming 2 February 7th 06 05:29 AM
ideas - Query table refresh MattShoreson[_34_] Excel Programming 4 July 6th 05 11:27 AM
Help! Query table refresh hangs excel jbhan Excel Programming 0 April 29th 05 09:24 PM
Timing of automatic query refresh and macro pivot table refresh dutty Excel Programming 2 December 1st 04 07:19 PM


All times are GMT +1. The time now is 11:12 AM.

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

About Us

"It's about Microsoft Excel"