View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Robert McCurdy Robert McCurdy is offline
external usenet poster
 
Posts: 102
Default Excel 2002 Workbook Opens Very Slowly

You have objects all over the pace.
Little rectangles with no visible boarders or colour.
Goto F5 Special Objects ok then hit delete.

Save and the file size should drop to 31k.


Regards Robert
"JT Lovell" wrote in message ...
I have a very mundane Excel workbook that is used by my department to keep our calendar. It has no macros and no formulas at all. However, it takes over 2 minutes to open the workbook from every computer I've tried it on. I've checked for viruses using McAfee (updated daily) without finding anything at all.

You can download the workbook at http://jadedharem.no-ip.info/jadedha...ngCalendar.xls

Copy and pasting the cells onto a new workbook seems to fix the problem temporarily (it'll open in under 10 seconds), however later deleting of a single row will cause the problem to reappear. I've also tried using SaveAs and renaming it with no improvement.

I'm using Excel 2002 SP-1 running on Windows XP SP-1. If anyone has any ideas or suggestions on what could be causing this I would appreciate it!

--
JT Lovell


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 21/02/2004