Odd behavior...recalculating, refreshing?

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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

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.


"Charles Williams" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>
>