cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Help us get a better understanding of what this Community means to you by taking our quick survey over here.

Integrations

Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
1
Ask
2
Comments

Linked excel sheets not updating

Linked excel sheets not updating

Dhwestfield
Explorer | Level 3

I have a question that has been puzzling my team as we use Excel as our main system in our business, with many separate files that have cells linked together.

 

We have a shared file on dropbox that allows us to all access and update these excel files.

 

Our issue is that if my teammates or I update one excel file, the other files that are linked to it will not update accordingly unless our administrator goes in and manually opens each file. Only when this happens, the updates flow through to the files according to the updates my teammates and I have made.

 

This causes some issues because at times we are not able to continue our work until the administrator opens the files to allow the updates to flow through into them. This also creates issues because only the administrator is able to create links between separate excel files.

 

We are looking for a solution that could enable all team members to preform these tasks, without having to bother the administrator to open the files so the liked cells information can flow through.

 

One side point I would like to mention is that the administrator typically will use excel on the desktop, while many team members are using "excel for the web".

 

On the top of my excel for the web page, it has a yellow message that reads, "Links Disabled, Links to external workbooks are not supported and have been disabled".  - I have a feeling this has something to do with it. 

 

Our team members currently have a mix of Apple and Windows computers.

1 Accepted Solution

Accepted Solutions

Re: Linked excel sheets not updating

Mark
Super User II

Hi @Dhwestfield 

 

You almost certainly need to be using the desktop versions of Excel on your machines for this to work. However what I would say is that the other issue you MAY run in to is that if in Excel the links are not configured as relative (if thats possible) they wont work and update unless every single user has exactly the same folder structure set up. This is because if not Excel wont know where to find the files as they wont be where its expecting them.


 


:penguin::penguin: - :penguin: - :penguin: - :penguin:


Heart Did this post help you? If so please mark it for some Kudos below. 


:white_check_mark: Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.


:arrows_counterclockwise: Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible! 


 

View solution in original post

2 Replies 2

Re: Linked excel sheets not updating

Mark
Super User II

Hi @Dhwestfield 

 

You almost certainly need to be using the desktop versions of Excel on your machines for this to work. However what I would say is that the other issue you MAY run in to is that if in Excel the links are not configured as relative (if thats possible) they wont work and update unless every single user has exactly the same folder structure set up. This is because if not Excel wont know where to find the files as they wont be where its expecting them.


 


:penguin::penguin: - :penguin: - :penguin: - :penguin:


Heart Did this post help you? If so please mark it for some Kudos below. 


:white_check_mark: Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.


:arrows_counterclockwise: Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible! 


 

Re: Linked excel sheets not updating

Dhwestfield
Explorer | Level 3

Thank you! This is helping us get closer to our goal, very helpful. Now this leads me to the relative links issue.. Any insight on how to ensure that works? I used the desktop version and I was able to have the information flow through to a linked excel spreadsheet, but when I opened the file it prompted me to update the file, and then im assuming that because our folders are not all set up the same my computer had me locate the file in my documents in order to pull the information. It would be great if we could find a way to have the links be "relative", so that it could smoothly update the files. 

 

One side observation I have noticed is when I select a linked cell, in the function bar it shows the employees name who made the link, and only that employee can smoothly update the files. I am wondering if creating the "relative" links will cause the names to go away therefor allowing everyone to freely update the files and flow the information from other files through. 

 

Example of one of the function bars is:='C:/Users/**EMPLOYEE NAME**/Dropbox/SeptemberShared/Portfolio/[September Porfolio.xlsx]Holdings!$F$22

 

Thank you for any insight you may have on this, it is very appreciated 

Who's talking

Top contributors to this post

  • User avatar
    Dhwestfield Explorer | Level 3
  • User avatar
    Mark Super User II
What do Dropbox user levels mean?
Need more support?