Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Control of links
Hi all,
I want to know if it's possible to have a register of the cells changed by external links. I have a WB connected with other WB's and We need to control the changes. Any ideas? Thanks a lot to all, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Control of links
Make a copy of the workbook with a different name.
Open the first copy with links refreshed. Open the second copy without refreshing the links Run a sheet-by-sheet cell-by-cell comparision. -- Gary''s Student - gsnu200742 "Tse" wrote: Hi all, I want to know if it's possible to have a register of the cells changed by external links. I have a WB connected with other WB's and We need to control the changes. Any ideas? Thanks a lot to all, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Control of links
"Tse" wrote in message
... Hi all, I want to know if it's possible to have a register of the cells changed by external links. I have a WB connected with other WB's and We need to control the changes. Any ideas? Thanks a lot to all, If all the cells which linked to external links were named (<Insert<NameDefinetype name<OK you could then produce a list of such cells<Insert<Name<Paste<Paste List. This is a bit clumsy and presumes you know where all the cells are in the first place and that no more external links are created without also naming and adding to the list. You could also display formulas (<Tools<Options<View<Formulas) which will then show external links instead of values. This is also clumsy but doesn't rely on a presumption of knowing the cells containing external links. I'm sure (hope) there's a better way. Regards. Bill Ridgeway Computer Solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Control dialog box control tab | Excel Discussion (Misc queries) | |||
Control tab does not appear in format control dialogue box | Excel Discussion (Misc queries) | |||
spinner format control has no control tab | Excel Worksheet Functions | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) |