Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I need to save or Highlighted the changes in a WB with external links. I need to receive some information like: cells changed, date, user. Anyone knows some possibility to solve this problem? Thanks a lot to all, |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is a very simple trick:
1. make 2 copies of the workbook, each with a different name 2. open them both, one with links refreshed, one without the refresh 3. write some simple VBA to do a sheet-by-sheet cell-by-cell comparison -- Gary''s Student - gsnu200741 "Tse" wrote: Hi all, I need to save or Highlighted the changes in a WB with external links. I need to receive some information like: cells changed, date, user. Anyone knows some possibility to solve this problem? Thanks a lot to all, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linked spreadsheets failing to recognised that the linked file is | Excel Discussion (Misc queries) | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
External link only works for numbers -- for text values, #N/A is displayed unless linked file is open | Links and Linking in Excel | |||
Save without prompted and activate external file | Excel Programming |