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?

Odd behavior...recalculating, refreshing?
 

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" wrote in message
...
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?

Odd behavior...recalculating, refreshing?
 

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" wrote in message
...
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" wrote in message
...
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?