Workbook VERY slow to open

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
Greetings,

I have a workbook that is very very slow to open.

The details:

The workbook is very similar in structure to other workbooks that don't share this "slow to open" issue.
The workbook has quite a few formulas built into the sheet.

Not sure how to proceed...:eek:
 
I search around online a bit and decided to try help->detect and repair ->discard my customized settings and restore default settings.

It ended up reducing the code stored in various modules in my personal wkbk to a subset of what I had before the attempt...so much for that...(fortunately I back stuff up)

Now, when I try to open the personal workbook it says the workbook is already open...i can't help but think these problems are somehow related. is it time to retire excel 2003 or is there a way gain original functionality?
 
Upvote 0

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,216,111
Messages
6,128,899
Members
449,477
Latest member
panjongshing

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top