We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here.

Forum Discussion

JSEURO's avatar
JSEURO
Helpful | Level 5
8 years ago

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...
Share
  • Jane's avatar
    Jane
    8 years ago

    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's avatar
Jane
Icon for Dropbox Staff rankDropbox Staff

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

alva114's avatar
alva114
Helpful | Level 5
8 years ago

Well, there are many cases in which the Excel file formulas stop working. This generally happens due to some type of issues, corruption, or due to some mistake in the Excel workbook. Moreover to fix the common issues in Excel file it is recommended to update your file and Windows operating system.

 

About Create, upload, and share

Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!