ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel File Taking Forever to Open (https://www.excelbanter.com/excel-discussion-misc-queries/190866-excel-file-taking-forever-open.html)

MEAD5432

Excel File Taking Forever to Open
 
I am trying to open a file that is only 462KB and Excel just hangs. The
program ends up becoming non-responsive and I have to close it.

It doesn't have any problem opening any other file, just this specific one.
I have tried opening from inside Excel as well as double-clikcing on the file
itself.

I have "Ignore other applications" checked in options.

I am using Office 2000 in XP SP2.


MEAD5432

Excel File Taking Forever to Open
 
Just a quick addition - Excel asks if I want to disable the macros in the
file. There shouldn't be any macros but I have tried both enabling and
disabling.

"MEAD5432" wrote:

I am trying to open a file that is only 462KB and Excel just hangs. The
program ends up becoming non-responsive and I have to close it.

It doesn't have any problem opening any other file, just this specific one.
I have tried opening from inside Excel as well as double-clikcing on the file
itself.

I have "Ignore other applications" checked in options.

I am using Office 2000 in XP SP2.


Dave O

Excel File Taking Forever to Open
 
Not sure if 2000 has this feature, but in Excel 2003's menu you can
click Help Detect and Repair. This may help.

Dave O
Eschew obfuscation

joel

Excel File Taking Forever to Open
 
If you have any Module sheets in VBA excel will ask if you want to enable a
macro even when you have no macros. You need to delete the Module to get the
message from appearing.

"MEAD5432" wrote:

Just a quick addition - Excel asks if I want to disable the macros in the
file. There shouldn't be any macros but I have tried both enabling and
disabling.

"MEAD5432" wrote:

I am trying to open a file that is only 462KB and Excel just hangs. The
program ends up becoming non-responsive and I have to close it.

It doesn't have any problem opening any other file, just this specific one.
I have tried opening from inside Excel as well as double-clikcing on the file
itself.

I have "Ignore other applications" checked in options.

I am using Office 2000 in XP SP2.


MEAD5432

Excel File Taking Forever to Open
 
That didn't work out. Still taking forever. Thanks for the suggestion.

"Dave O" wrote:

Not sure if 2000 has this feature, but in Excel 2003's menu you can
click Help Detect and Repair. This may help.

Dave O
Eschew obfuscation


MEAD5432

Excel File Taking Forever to Open
 
I checked the VBA page to see if there were any modules. There is the list
of three (Module 1-3), but they don't have any script in them. Would there
be someplace else where that macro or module be hiding?

"Joel" wrote:

If you have any Module sheets in VBA excel will ask if you want to enable a
macro even when you have no macros. You need to delete the Module to get the
message from appearing.

"MEAD5432" wrote:

Just a quick addition - Excel asks if I want to disable the macros in the
file. There shouldn't be any macros but I have tried both enabling and
disabling.

"MEAD5432" wrote:

I am trying to open a file that is only 462KB and Excel just hangs. The
program ends up becoming non-responsive and I have to close it.

It doesn't have any problem opening any other file, just this specific one.
I have tried opening from inside Excel as well as double-clikcing on the file
itself.

I have "Ignore other applications" checked in options.

I am using Office 2000 in XP SP2.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com