# Excel Really won't calculate (Yes I know F9)

#### DCUnited

##### New Member
I have a very big file (23MB) that has always worked fine until recently when I added some more columns. The file size increased by about 2MB and now it refuses to calculate.

The file is full of vlookup() and Index() functions but they have always seemed to work in the past with no problem.

I always keep my files on autocalc and even with autocalc I still have the calculate signal in the bottom left. Now it appears everything is calculating correctly with the exception of the charts which won't update...

I contacted Microsoft and even sent them the file but they haven't been able to figure it out (cost me \$35).

The guys at Microsoft said it wasn't a problem but I read about a limit on dependent cells, how do you check the number of dependent cells you have in a workbook?

Does anyone know what would cause this to happen? Vlookups? Index? File too large? (although I have a co-worker with a 45mb file that works fine)

Any help would be appreciated.

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Thank you both...

In this case where I have hit the limit what makes more sense to use Index or Vlookup?

If I have a vlookup range of (A2:B4) is that 4 dependencies?

If I have an Index range of (B2:B4) is that 2 dependencies.

If the cell just says =B2 is that 1 dependent?

I guess I still don't fully understand what a dependent cell is...

Has anyone else run into this problem and if so what did you do to fix it?

Dependencies have to do with what cells need to be calculated before other cells can be computed.

If cell A1 references cell B1, then B1 must be computed 1st.

If cell B1 itself references cell C1, then C1 must have its value before either of the others.

Give us an idea of how many cells - about - have formulas, how many sheets they are on, and what type formulas - give examples - they are.

Also, go back to the Decision models web site and read up on fast computing tips.

DCUnited said:
Has anyone else run into this problem and if so what did you do to fix it?

Sure, pretty often I see monstrous files that are unstable and take long time to calculate. You have too start from the beginning. Can it be done smarter? More efficient? Most certain. Maybe a VBA approach is required, a macro that you can run when needed instead of formulas that constantly recalculates.

fairwinds said:
DCUnited said:
Has anyone else run into this problem and if so what did you do to fix it?

Sure, pretty often I see monstrous files that are unstable and take long time to calculate. You have too start from the beginning. Can it be done smarter? More efficient? Most certain. Maybe a VBA approach is required, a macro that you can run when needed instead of formulas that constantly recalculates.

fairwinds is right ( as usual ) - in addition to more efficient formula sets there's also the possibility of using code to all or part of your current formula calculation.

Replies
33
Views
1K
Replies
16
Views
688
Replies
6
Views
915
Replies
16
Views
905
Replies
1
Views
287

1,218,619
Messages
6,143,509
Members
450,492
Latest member
Rusbus1972

### 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.

### Which adblocker are you using?

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

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