Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent previous entered data from updating
File One.xls contains cells that pull information (i.e. a percentage of some
number) from Two.xls. I want to be able to update information (the percentage) in Two.xls, then go back into One.xls and have the previous information stay the same (using the old percentage) and have any new data use the updated percentage. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent previous entered data from updating
Sounds like you are dealing with linking formulas.
As long as they remain formulas they will update with any change of data in Two.xls You must copy and paste special values which destroys the formulas unless you copy and paste to a new range. I think you will have to use VBA event code. Gord Dibben MS Excel MVP On Thu, 13 May 2010 12:54:01 -0700, ksell87 wrote: File One.xls contains cells that pull information (i.e. a percentage of some number) from Two.xls. I want to be able to update information (the percentage) in Two.xls, then go back into One.xls and have the previous information stay the same (using the old percentage) and have any new data use the updated percentage. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
Prevent duplicate data from being entered into the same column | Excel Worksheet Functions | |||
How do I prevent data from being entered into a particular cell? | Excel Discussion (Misc queries) | |||
how to prevent Excel from reformatting a chart wen updating data? | Charts and Charting in Excel | |||
Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) |