A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

2002 Excell - how do I stop it automatically updating from my database?



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2004, 10:00 AM
Colin
external usenet poster
 
Posts: n/a
Default 2002 Excell - how do I stop it automatically updating from my database?

I have office, I think it is 2002, it might be 2003 (new
job). When I open a spreadsheet that contains links to a
database, it should give me the option to enable refresh
or disable refresh. Well it doesn't, it just
automatically refreshes the data.
How do I get it to behave and ask me the question / give
me the choice?
  #2  
Old May 10th, 2004, 01:58 PM
Bill Manville
external usenet poster
 
Posts: n/a
Default 2002 Excell - how do I stop it automatically updating from my database?

Colin wrote:
I have office, I think it is 2002, it might be 2003 (new
job). When I open a spreadsheet that contains links to a
database, it should give me the option to enable refresh
or disable refresh. Well it doesn't, it just
automatically refreshes the data.
How do I get it to behave and ask me the question / give
me the choice?


Assuming the data is retrieved using a query, you would change the
QueryTable's properties. With the cursor in the table of results of
the query use Data / Import External Data / Data Range Properties and
clear the box that indicates Refresh on Open.

To manually refresh you would then use Data / Refresh Data.

If you have a number of different QueryTables you might want to
automate their refresh using a macro. Come back if you need help with
that.

If Data Range Properties is greyed out then the sheet might be
protected (Tools / Protection / Unprotect Sheet). Otherwise it may not
be a query table at all but some other form of link, in which case you
would go to Edit / Links / Startup Properties.

If this doesn't get you to the solution report back what you found at
each stage and we'll try to help further.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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