Odd behavior...recalculating, refreshing?

[M. Authement]

This is driving me crazy. I have a spreasheet with lots of calculations
that I use every morning. When I open the file, I see the title bar,
command bars, tabs, etc. But, where the first sheet is I see all white (no
gridlines, no values). I can then see values from other worksheets being
filled in. Once they are filled in, I see the worksheet as it should be.

I have the workbook on Manual Calc, I set Personal.xls to Manual Calc, there
are no other workbooks open. The formulas used are from an add-in (Proficy
from GE Fanuc, previously Mountain Systems) which basically retrieves data
from an SQL database. I tried setting each worksheet's EnableCalculation
property to False, but every time I open the workbook up and check the
properties they are back to True. I don't know if it is really calculating
or not as it remains in the Calculate mode when it is done. I am using
Windows XP with Excel 2003. This issue seems to have started around the
time we upgraded from Office XP to 2003 and when I went from a desktop to a
laptop. Any thoughts on what might be happening?

 

[Charles Williams]

Is Proficy supposed to refresh all queries on open or not?
How would you control any refresh of data from the DB?


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

 

[M. Authement]

It didn't in the past. Normally the data is refreshed during calculation.
Just some other info on my system: Pentium M 1.73 MHz, 1Gig RAM. I do not
remember what the desktop was, though I believe it had a faster processor
but less RAM.