Excel 2003 Sheet – References are not refreshed

Problem Statement: Excel Sheet (Excel 2003) is having lot of references to other sheets.
After opening the sheet, the references are not refreshed.

Solution : This is bug in Excel 2003
Manual Solution: Use CNTRL+ALT+ F9 – This will refresh the references
Macro Solution: Application.CalculateFull

-o-

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s