This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello, my customer service team has a very large excel spreadsheet they use for scheduling. This spreadsheet has a lot of formulas to help calculate PTO among other things. We are trying to make it accessible to the Customer Service Reps by sharing within a SharePoint site. I have locked the permissions down on the library to read only for the reps, also they are unable to download. The reps only have the online version of excel, they do not have the desktop apps. Whenever the sheet is updated, the formulas break in the online version. The desktop version updates fine and all the formulas work however when you open the online sheet it only shows #### in the cells that have been update and contain formulas. I have attached a screen shot of the error below. Thank you so much for any help!
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share a test file to reproduce your issue?
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community