software

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

quot;M. Authementquot; gt; wrote in message
...
gt; This is driving me crazy. I have a spreasheet with lots of calculations
gt; that I use every morning. When I open the file, I see the title bar,
gt; command bars, tabs, etc. But, where the first sheet is I see all white
gt; (no gridlines, no values). I can then see values from other worksheets
gt; being filled in. Once they are filled in, I see the worksheet as it
gt; should be.
gt;
gt; I have the workbook on Manual Calc, I set Personal.xls to Manual Calc,
gt; there are no other workbooks open. The formulas used are from an add-in
gt; (Proficy from GE Fanuc, previously Mountain Systems) which basically
gt; retrieves data from an SQL database. I tried setting each worksheet's
gt; EnableCalculation property to False, but every time I open the workbook up
gt; and check the properties they are back to True. I don't know if it is
gt; really calculating or not as it remains in the Calculate mode when it is
gt; done. I am using Windows XP with Excel 2003. This issue seems to have
gt; started around the time we upgraded from Office XP to 2003 and when I went
gt; from a desktop to a laptop. Any thoughts on what might be happening?
gt;
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.quot;Charles Williamsquot; gt; wrote in message
...
gt; Is Proficy supposed to refresh all queries on open or not?
gt; How would you control any refresh of data from the DB?
gt;
gt;
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.1 now available
gt; www.DecisionModels.com
gt;
gt; quot;M. Authementquot; gt; wrote in message
gt; ...
gt;gt; This is driving me crazy. I have a spreasheet with lots of calculations
gt;gt; that I use every morning. When I open the file, I see the title bar,
gt;gt; command bars, tabs, etc. But, where the first sheet is I see all white
gt;gt; (no gridlines, no values). I can then see values from other worksheets
gt;gt; being filled in. Once they are filled in, I see the worksheet as it
gt;gt; should be.
gt;gt;
gt;gt; I have the workbook on Manual Calc, I set Personal.xls to Manual Calc,
gt;gt; there are no other workbooks open. The formulas used are from an add-in
gt;gt; (Proficy from GE Fanuc, previously Mountain Systems) which basically
gt;gt; retrieves data from an SQL database. I tried setting each worksheet's
gt;gt; EnableCalculation property to False, but every time I open the workbook
gt;gt; up and check the properties they are back to True. I don't know if it is
gt;gt; really calculating or not as it remains in the Calculate mode when it is
gt;gt; done. I am using Windows XP with Excel 2003. This issue seems to have
gt;gt; started around the time we upgraded from Office XP to 2003 and when I
gt;gt; went from a desktop to a laptop. Any thoughts on what might be
gt;gt; happening?
gt;gt;
gt;
gt;