You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
Using formulas in Excel files saved in Dropbox
This issue is very recent, and happened a couple of days ago when I noticed that I was not able to build certain formulas in my Excel files shared in Dropbox. When I start to build a formula (usually...
Hey JSEURO,
Thanks for getting in touch on Community, please let me clarify!
Just as an initial troubleshooting step, I would advise you to downgrade to the latest stable build.
Secondly, please note that the external location referenced within an Excel is a link to your HD drive, so when your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example "/JaneMacBookPro/Jane/File", and that location is no longer accessible from a different computer.
Hope this helps you clarify!
If you need to ask anything else about it, please reply to this post, I'd be glad to follow-up.
Kind regards,
JaneA
Jane
Dropbox Staff
Dropbox StaffHey JSEURO,
Thanks for getting in touch on Community, please let me clarify!
Just as an initial troubleshooting step, I would advise you to downgrade to the latest stable build.
Secondly, please note that the external location referenced within an Excel is a link to your HD drive, so when your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example "/JaneMacBookPro/Jane/File", and that location is no longer accessible from a different computer.
Hope this helps you clarify!
If you need to ask anything else about it, please reply to this post, I'd be glad to follow-up.
Kind regards,
JaneA
