Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing the target worksheet
My target worksheet (just one) is linked to several source worksheets (about
50 files). If I want to edit the target worksheet (say, adding additional rows), does it mean that I have to open all my sources such that the links can be kept? I had tried to edit the target without opening the sources, the linked addresses will all be jumbled up after adding the new rows. If it is indeed required for the sources to be opened, can EXCEL open 50 files at the same time? Any memory problem here? Thanks. zhj23 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
Excel VBA Target Worksheet change | Excel Discussion (Misc queries) | |||
Worksheet locked for editing | New Users to Excel | |||
Using VBA to create a new worksheet, and then target new worksheet | Excel Discussion (Misc queries) | |||
What do I need so I can open an Excel worksheet for editing? | Excel Worksheet Functions |