| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cut/Copy and Paste Functions without old links
I have a function on current sheet which refers to cells on other sheet
PSUML5'!F15 ie. Cell F15 on Sheet PSUML5 When I cut or copy this current sheet to another sheet, it still refers to the original sheet ='[Build Summary - trial.XLS]PSUML5'!F15 What do I do if I just want the function to appear as : = PSUML5F15 on the new sheet ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I paste links and keep formats | Excel Discussion (Misc queries) | |||
| need custom cut and paste functions | New Users to Excel | |||
| Losing data on copy and paste functions | Excel Worksheet Functions | |||
| PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
| Paste functions into a new XLS | Excel Worksheet Functions | |||
Linear Mode
