+ Reply to Thread
Results 1 to 5 of 5

Share workbook wont update linked sheets

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Share workbook wont update linked sheets

    HI All

    I have a shared workbook that has 7 users constantly using it daily, it has some formulas linked to another sheet on the netwrok drive, but because its a shared workbook i can create a macro to open the sheet it is calculating from, and it doesnt work by putting a hyperlink in there....

    It works when i unshare it and put a macro in to open up the data sheet on activation, but i dont know how to get it to work when its shared?

    Currently when its shared it returns #Value where the formulas are to a linked sheet

    Could someone give me some advice please?

    THanks

    Dan

  2. #2
    Registered User
    Join Date
    06-14-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: Share workbook wont update linked sheets

    There are some formulae that just don't work on external spreadsheets (unless they are open) like GETPIVOT for example.

    What's the formula that returning the error?
    <--- Please click the star to say thank you

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Share workbook wont update linked sheets

    Right in my shared workbook i have this......

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Which doesnt work in a shared workook,

    When i turn it into a xlsm file and use this

    Please Login or Register  to view this content.
    It works fine.

    Problem is i cant use that macro in the shared workbook

  4. #4
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Share workbook wont update linked sheets

    Does anyone have any ideas how i can do this?

    I have been trying for the last 24 hours and still cant get the shared workbook to calculate the formulas. I have to update as the formula is linked to another workbook, and have read that you can tick the external contest in trust settings to trust all external content, but it still doesnt calculate just returns #value

  5. #5
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Share workbook wont update linked sheets

    Dont worry i link another sheet in my shared workbook, so rather than a calculation, it just equalled whatever was in that cell in my other workbook, then from that data i created the calculations in the sheet where orignally the above formula was.

    This works now on the shared workbook

+ 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. Share Workbook (update changes time)
    By menca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2010, 10:52 AM
  2. Share Workbook - Update Changes
    By ben_sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2006, 08:10 AM
  3. HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK
    By uttam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK
    By uttam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK
    By uttam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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