Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking w/Paste Special
Hello,
I am trying to link a column in one spreadsheet to another spreadsheet. When I initially copy and paste special everything copies over well and if I make a change it reflects in the linked column. However, if I insert a new row in the original sheet, it does not insert and paste in the linked sheet. Does anyone know of a way to make this work? Thank you. -- LFP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking w/Paste Special
That is one of the pitfalls of linking. There is no way for modifications of
the source layout to be tranlated into the destination. You have to do it manually. -- HTH... Jim Thomlinson "LFP" wrote: Hello, I am trying to link a column in one spreadsheet to another spreadsheet. When I initially copy and paste special everything copies over well and if I make a change it reflects in the linked column. However, if I insert a new row in the original sheet, it does not insert and paste in the linked sheet. Does anyone know of a way to make this work? Thank you. -- LFP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
Inactivating of "Paste special" while linking charts | Charts and Charting in Excel | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste Special and Linking | Excel Discussion (Misc queries) |