+ Reply to Thread
Results 1 to 1 of 1

Auto update multiple SharePoint Excel sheets data in another SharePoint, Excel 2013

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    Bengaluru
    MS-Off Ver
    2013
    Posts
    4

    Auto update multiple SharePoint Excel sheets data in another SharePoint, Excel 2013

    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.
    Last edited by ASRKumar; 10-29-2020 at 03:12 AM. Reason: Minor changes

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Link data from multiple sharepoint excel docs
    By thompsondanny10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2018, 03:20 PM
  2. [SOLVED] Using PowerQuery(2013) to Access and Update Sharepoint File
    By dsharman in forum Excel General
    Replies: 2
    Last Post: 05-31-2018, 01:39 PM
  3. VBA to select SharePoint Content Type when saving Excel file to SharePoint
    By Luffk73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2017, 05:22 PM
  4. Replies: 0
    Last Post: 10-05-2015, 10:45 PM
  5. Excel 2010, Excel 2013 and SharePoint
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 01:32 PM
  6. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  7. Update SharePoint List from Excel using VBA
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2013, 03:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1