| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell data protection
I have used a simple IF formula to pull data from another file, but once i have pulled this information over i wont it to be saved as the actual data. Because the file i have 'if' copied the data over from is updated every month, and i dont wont the data on the new my sheet to be over copied each timeits opened. How do i do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell data protection
Before saving your worbook:
select your cell Copy Paste SpecialValues HTH -- AP "Tim" a écrit dans le message de ... I have used a simple IF formula to pull data from another file, but once i have pulled this information over i wont it to be saved as the actual data. Because the file i have 'if' copied the data over from is updated every month, and i dont wont the data on the new my sheet to be over copied each timeits opened. How do i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I connect data in cell C to data in cell D? | Charts and Charting in Excel | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Maximum data in cell | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Linear Mode
