Formulas won't update

chris997

New Member
Joined
Aug 24, 2009
Messages
2
Hey guys,

Having an odd issue; formulas between two sheets aren't updating unless I hit Ctl-alt-F9. (just a simple Sumif statement calculating between two sheets).

Have checked and calculations are set to automatic, and have tried swapping it off automatic and back on.

I'll be needing to hand this spreadsheet off to someone, so don't want to have them need to do anything to update the formulas.

Anyone have any ideas on this?? Thanks!

Chris
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,950
Office Version
365
Platform
Windows, Mobile, Web
Do you have any VBA-code in the file?

Did you try to close the Excel application and reopen Excel and the file?
 

chris997

New Member
Joined
Aug 24, 2009
Messages
2
Do you have any VBA-code in the file?

Did you try to close the Excel application and reopen Excel and the file?
Wow, that did it! I'd used some code in a separate workbook; visual basic editor kept opening automatically, guess that might have been causing the issue. Thanks for the help!
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,950
Office Version
365
Platform
Windows, Mobile, Web
You're welcome, glad it's solved.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,927
Messages
5,447,348
Members
405,447
Latest member
WPY

This Week's Hot Topics

Top