M
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?
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?