cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Learn all about how Alex on the Community team used Dropbox in college here!

Dropbox files & folders

Get in sync with the Dropbox Community. Our members can answer all your questions on Dropbox files and folders. Join a discussion or start your own today.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Financial Model formulas break when uploading .xlsx sheets to Dropbox

Financial Model formulas break when uploading .xlsx sheets to Dropbox

JenniJ
New member | Level 2

CFO sent .xlsx Finanical Model with formulas working (10 sheets in book).

When I upload it to our Dropbox Business account, the formulas break (#REF)

 

How can I upload the entire Financial Model into our Dropbox Business account without formulas breaking?

 

Using a Mac OS Big Sur, version 11.1

3 Replies 3

Re: Financial Model formulas break when uploading .xlsx sheets to Dropbox

Jay
Dropboxer
Hi @JenniJ, thanks for messaging today!

It depends on what the formulas are referring to, which is why this could be happening.

Are they pointing to value in the same document, or another document entirely? Are there any macros involved in the formulas

This will help me to assist further!

Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: Financial Model formulas break when uploading .xlsx sheets to Dropbox

JenniJ
New member | Level 2

Hi, Jay.

 

Thank you for responding.  There might be macros within the formulas.  Everything is pointing to values within the same document.

 

 

Re: Financial Model formulas break when uploading .xlsx sheets to Dropbox

Jay
Dropboxer
Are the formulas breaking when you download the file to your computer,  or is it only when previewing the file on the Dropbox site?

What happens if you preview in on the Excel Online site, via Dropbox?

Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Who's talking

Top contributors to this post

What do Dropbox user levels mean?
Need more support?