LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
M. Authement
 
Posts: n/a
Default 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing OLAP cube by date using VBA Hugo Rask-Jensen Excel Worksheet Functions 0 January 31st 06 08:11 PM
Added new columns - Pivot Table not refreshing - why? Joan Sims Excel Worksheet Functions 1 January 12th 06 12:31 AM
problem refreshing data query on yahoos jcoudrie0734 Excel Discussion (Misc queries) 0 October 4th 05 12:14 AM
How can I maintain spreadsheet formating when refreshing import da Jason Excel Discussion (Misc queries) 0 July 8th 05 09:31 PM
VC Problem refreshing pivot table Vickster3659 Excel Discussion (Misc queries) 6 June 1st 05 03:15 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"