Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble with seeing formula in formula bar
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble with seeing formula in formula bar
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble with seeing formula in formula bar
Hi Joy,
Missed the part of the refresh feature for external data, which I am not familiar with. Take a look at Help topic "Refresh imported data" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trouble with formula | Excel Discussion (Misc queries) | |||
Trouble with formula | Excel Worksheet Functions | |||
Trouble with Syntax - IF formula | New Users to Excel |