Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not recognizing new data
I have a workbook with formulas across sheets. All the sheets with formulas are driven off of data that is manually pasted into three sheets. I have two formulas that reference formulas that combine some of the data from the manually pasted data. For some reason in some cases the formulas don't refresh when I paste in the new data. However, when I manually go to the formulas that are not showing the new data and I refresh the formula buy hitting F2 and then enter, the new data appears. This tells me the formulas are correct but they, for some reason, are not refreshing when the new data is pasted. Does anyone know how to fix this problem? Thanks for your assistance. -- malakingaso ------------------------------------------------------------------------ malakingaso's Profile: http://www.excelforum.com/member.php...o&userid=31273 View this thread: http://www.excelforum.com/showthread...hreadid=510144 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not recognizing new data
Under Tools/Options on the Calculation tab.
Set to Automatic Or press F9 to recalcualte "malakingaso" wrote in message ... I have a workbook with formulas across sheets. All the sheets with formulas are driven off of data that is manually pasted into three sheets. I have two formulas that reference formulas that combine some of the data from the manually pasted data. For some reason in some cases the formulas don't refresh when I paste in the new data. However, when I manually go to the formulas that are not showing the new data and I refresh the formula buy hitting F2 and then enter, the new data appears. This tells me the formulas are correct but they, for some reason, are not refreshing when the new data is pasted. Does anyone know how to fix this problem? Thanks for your assistance. -- malakingaso ------------------------------------------------------------------------ malakingaso's Profile: http://www.excelforum.com/member.php...o&userid=31273 View this thread: http://www.excelforum.com/showthread...hreadid=510144 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Formulas in source data | Charts and Charting in Excel |