What's wrong with this file?? (creating new rows in a table make Excel crash)

[dourpil]

Hi all,

I'm working on an Excel file which makes the program go crazy:

https://drive.google.com/file/d/0B2fgXVB12iSvNW5vNGFqTmFPWkE/edit?usp=sharing

It has some conditional formatting on most rows and some data validation aswell. All quite basic though so I wonder what's making it stress so much

IDK if it'll do it for you aswell (maybe the computer makes it crash but I've tried on 2 machines), but when I extend the table (creating new "blank" rows for it), well.. Excel just crashes.


-


Also, earlier with this file when it wasn't crashing like that, I had about 20 rows and when I tried to save, Excel told me that one or more formulas were exceeding the 8192 thingies limit.

I don't know what I've done to it that's messing up so much. Any clue on how I can check for super-heavy calculations cells? I didn't think they were some at all.

 

[patel45]

your link ask for permission

 

[dourpil]

your link ask for permission

oops! Should be good to go

 

[tweedle]

What's the data validation for Column P suppose to be?

It has just "= "

 

[dourpil]

What's the data validation for Column P suppose to be?

It has just "= "

Weird. It's =indirect($C$2) in my file

 

[dourpil]

Up? IDK if that's allowed o:]

 

[dourpil]

I'll up this once more because Excel crashed several times even though I tried to start a new file from scratch

 

[tweedle]

I downloaded the file again and have run through several iterations and attempted to find invalid object references to no avail.
The workbook appears to now be working fine.

 

[Cool blue]

What versions of Windows and excel are you running?