Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 354
Default Problems Opening Excel file

I have an Excel file that is 2.87 MB, which doesn't seem too terribly large.
However, when I go to open it, it takes _forever_, so to speak, and ends up
locking up most my system sometimes. I have about 36 GB of free space on my
hard drive, and am not sure why the file is taking so long to open. Any
suggestions?

My OS info is as follows:

Microsoft Windows 2000
5.00.2195
Service Pack 4

653,296 KB RAM

I have Office 2003.

The doc is stored on my desktop. I have this problem whether I am running
other programs, or not.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Problems Opening Excel file

What specifically is in the workbook? Pivot tables, plots, etc?


Daniel wrote:
I have an Excel file that is 2.87 MB, which doesn't seem too terribly large.
However, when I go to open it, it takes _forever_, so to speak, and ends up
locking up most my system sometimes. I have about 36 GB of free space on my
hard drive, and am not sure why the file is taking so long to open. Any
suggestions?

My OS info is as follows:

Microsoft Windows 2000
5.00.2195
Service Pack 4

653,296 KB RAM

I have Office 2003.

The doc is stored on my desktop. I have this problem whether I am running
other programs, or not.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Problems Opening Excel file

I've had this problum before as well and there could be several things that
is slowing your file from opening.

Did you recently delete something?
If you did some of your formulas could still be trying to "refrence"

your deleted data. To search to see if you have errors like this go to one of
your worksheets go to "EDIT" then "FIND" (Find won't show up on the edit list
if you are on a chart) Then to check your workbook go to options and change
"worksheet" to "workbook". The rest can be as is("rows" and "formulas") If
you have formulas in your workbook then make sure you leave "Formulas" there.
It may not always show up in the cell value!
Did you move something?
If you cut something out or moved something from one book to another

like a worksheet, the cells that were linked to that moved sheets or data may
have followed it! So you may have "links" in your workbooks. This slows it
down, a little, but if you were to delete that other workbook you moved the
sheet from it slows it down a lot! It is trying to find a workbook that
doesn't exsist anymore becuase of the link! To fix this go to "Find" (like i
said previously) and simply look up "[", this is becuase a bracket signifies
a link to another workbook. So if you added brackets to your information,
that could also be the problum.

Hope that helps! Good luck!

"Daniel" wrote:

I have an Excel file that is 2.87 MB, which doesn't seem too terribly large.
However, when I go to open it, it takes _forever_, so to speak, and ends up
locking up most my system sometimes. I have about 36 GB of free space on my
hard drive, and am not sure why the file is taking so long to open. Any
suggestions?

My OS info is as follows:

Microsoft Windows 2000
5.00.2195
Service Pack 4

653,296 KB RAM

I have Office 2003.

The doc is stored on my desktop. I have this problem whether I am running
other programs, or not.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 354
Default Problems Opening Excel file

Apparently, the problem was that I did not have a service pack loaded. I
corrected this and now it opens fine.

Thanks for your input!

"Robert Brown" wrote:

I've had this problum before as well and there could be several things that
is slowing your file from opening.

Did you recently delete something?
If you did some of your formulas could still be trying to "refrence"

your deleted data. To search to see if you have errors like this go to one of
your worksheets go to "EDIT" then "FIND" (Find won't show up on the edit list
if you are on a chart) Then to check your workbook go to options and change
"worksheet" to "workbook". The rest can be as is("rows" and "formulas") If
you have formulas in your workbook then make sure you leave "Formulas" there.
It may not always show up in the cell value!
Did you move something?
If you cut something out or moved something from one book to another

like a worksheet, the cells that were linked to that moved sheets or data may
have followed it! So you may have "links" in your workbooks. This slows it
down, a little, but if you were to delete that other workbook you moved the
sheet from it slows it down a lot! It is trying to find a workbook that
doesn't exsist anymore becuase of the link! To fix this go to "Find" (like i
said previously) and simply look up "[", this is becuase a bracket signifies
a link to another workbook. So if you added brackets to your information,
that could also be the problum.

Hope that helps! Good luck!

"Daniel" wrote:

I have an Excel file that is 2.87 MB, which doesn't seem too terribly large.
However, when I go to open it, it takes _forever_, so to speak, and ends up
locking up most my system sometimes. I have about 36 GB of free space on my
hard drive, and am not sure why the file is taking so long to open. Any
suggestions?

My OS info is as follows:

Microsoft Windows 2000
5.00.2195
Service Pack 4

653,296 KB RAM

I have Office 2003.

The doc is stored on my desktop. I have this problem whether I am running
other programs, or not.

Reply
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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Probelm opening an excel 2000 file in excel 2003 Mark Excel Discussion (Misc queries) 1 February 13th 06 07:47 AM
Problems using Excel 2000 to open/save file saved in Excel 2003 [email protected] Excel Discussion (Misc queries) 1 June 29th 05 02:50 AM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 1st 05 11:31 PM


All times are GMT +1. The time now is 03:29 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"