Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
However, after I correct the invalid cell reference problem and the P&L (so as other financial statements) work perfectly again, the circular reference for finance lease cannot refresh / re-calculate itself automatically (and the cells still show "#ref"). The refreshing shortcut keys like F9 don't work. I was able to solve this by a silly method: clear the cells and re-input the formula again. However, is there any way to make it works automatically again (since my file will be password-protected before I sent to external parties)? Thank you. Read More