Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Refreshing OLAP cube by date using VBA | Excel Worksheet Functions | |||
Added new columns - Pivot Table not refreshing - why? | Excel Worksheet Functions | |||
problem refreshing data query on yahoos | Excel Discussion (Misc queries) | |||
How can I maintain spreadsheet formating when refreshing import da | Excel Discussion (Misc queries) | |||
VC Problem refreshing pivot table | Excel Discussion (Misc queries) |