Hi,
I want to auto update multiple Share point excel files data (single tab/work sheets) in different paths into Consolidated Share point Excel as different Tabs/Worksheets. Post that if any changes made to any of the excels consolidated sheet should be auto updated.
How can we do this in MS Excel 2013 for share point Excel files?
Note: I am able to partially achieve it by using 'Paste Link' but it will work for existing records/columns, if we create new records/rows (or) new columns in source sheet it will not work.
Is there anyway i can take entire source data including any new records & auto update in destination excel file?
Also i am not getting source format of excel in destination sheet when using 'Paste link' option.
Bookmarks