MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

I would refresh ALL unless ODBC or macro related....


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

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...


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.