Don't understand why it would remain locked on another formula
but the part of fixing with F2+Enter could be addressed
by the TrimALL macro as long as calculation is turned on.
Be sure to read the descriptions for and topics previous to
the actual macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Better try on a copy of the worksheet, not knowing what the
problem actually is or whether you have data that might be
destroyed (like dates in wrong format).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Joy" wrote in message oups.com...
hi -
I have a large spreadsheet (excel for mac 2004) -- when i move within
the various cells of the file, the formula bar does not update to
reflect the current cell that I am in. it remains locked on a prior
formula. I can sometimes "trick" it to work by clicking in a cell and
hitting return - that seems to do the job for a short period of time,
but inevitably the problem reoccurs. I have also confirmed that my
Calculations are set to Automatic.
I started noticing this problem after I imported external data (from a
csv file) and turned on the 'refresh' feature. I have no idea if this
is causing the problem.
Any thoughts/suggestions would be GREATLY appreciated!
Joy
PS there are a number of array formulas in the workbook -- don't know
if that is at all related.