refresh all versus refresh
Posted by john lesar on January 17, 2002 10:54 AM
I have a workbook in excel97 consisting of 3+ wrkshts. page one contains 3 parameters for page 2 and 3 external data queries thru odbc to a db.
para 1 = 01/01/2002, para 2= 01/01/2002, para 3= 01/05/2002. If I click refresh all button it brings back thr wrong data. if I click individually each worksheet REFRESH. It brings back the correct data.
I do the same in many spreadsheets but have never come across this??? PLEASE HELP.
Posted by Mark W. on January 17, 2002 11:12 AM
Have you enabled background refresh? If so, what
happens if you disable it? Does this workbook
have any macros?
Posted by Jack in UK on January 17, 2002 11:34 AM
Hi
I would refresh ALL unless ODBC or macro related....
HTH
JACK
PS on demand only thou:
Posted by jlesar on January 17, 2002 11:35 AM
enabled background refresh is off!
No macros!
Posted by Johne lesar on January 17, 2002 11:49 AM
Why do you say that????
Posted by Jack in UK on January 17, 2002 11:59 AM
Hi
Im the ODBC via VBA Script guru so im told and refresh ALL from bespoke sofwarer give guarentee (close as ) fresh current data, but only refresh as needed as it can be slow i have 500,000 to 1,000,000 cells of raw data ripped out by ODBC i do this everydat and update as well take a while but then i off Excel powered.
Just my way and my opinion, cant see the point of old data...
Rdgs
Jack
Posted by Mark W. on January 17, 2002 3:07 PM
Okay, now I've got to ask...
What constitutes "correct" and "wrong" data?
Please describe.
