Help needed - spreadsheet keeps crashing

[annaisakiwi]

Hi all

I have a spreadsheet that I've worked so hard on - but it is now hanging each time (sometimes crashing) whenever I update anything in it.

It does have alot of formula in it - but i've never experienced anything like this slow down before. Guess I'm wondering if it's my spreadsheet - or computer.. or ?

Any suggestions? I'm nervous to upload the full workbook here - but guessing i'd have to to get help with it?

Thanks

 

[Peter_SSs]

Have you been making any back-ups of the workbook?

 

[Alex Blakenburg]

Is your workbook warning you about circular references ?
Do you have any Event macros in the workbook ?
Is this the same workbook that you have your volatile color UDF functions in ? How many places are you using this ?
If you look in Home > Cell Styles can you see the group
Good, Bad and Neutral or do you have large volume of custom styles showing ?

 

[annaisakiwi]

Have you been making any back-ups of the workbook?

Not as such - stored on onedrive, so can go back on version history.

 

[annaisakiwi]

Is your workbook warning you about circular references ?
Do you have any Event macros in the workbook ?
Is this the same workbook that you have your volatile color UDF functions in ? How many places are you using this ?
If you look in Home > Cell Styles can you see the group
Good, Bad and Neutral or do you have large volume of custom styles showing ?

No circular references
No macros
Sorry what color UDF functions?
Yes can see Good, Bad and Neutral - no custom styles at all.

 

[Alex Blakenburg]

Sorry what color UDF functions?

These ones:

SumbyColour and Sumifs combined

Hi all I have a SumByColour writen in VBA - however i'm wanting to change this slightly to include a sumifs I want the Sum calculation to only total values between two dates. A date will be entered in for the Leave as at date (E3) - and I want the SumbyColor to only sum between this entered...

www.mrexcel.com

But if no macros means that it is not an xlsm or xlsb file then that rules that out anyway.

Are you using a lot of volatile functions ie INDIRECT or OFFSET or have thousands of rows with conditional formatting ?

 

[annaisakiwi]

These ones:

SumbyColour and Sumifs combined

Hi all I have a SumByColour writen in VBA - however i'm wanting to change this slightly to include a sumifs I want the Sum calculation to only total values between two dates. A date will be entered in for the Leave as at date (E3) - and I want the SumbyColor to only sum between this entered...

www.mrexcel.com

But if no macros means that it is not an xlsm or xlsb file then that rules that out anyway.

Are you using a lot of volatile functions ie INDIRECT or OFFSET or have thousands of rows with conditional formatting ?

Thanks so much - no not that workbook

It was conditional formatting... had an error where it was applying the format to full columns. Thanks so much!

 

[Alex Blakenburg]

Thank you for letting us know. Glad we could help.