When i try to use it to another, all formulas in it stop working and it appears the file works only on a computer where it's made I've been the only one using this for that past few years, but i need to allow other users to access the workbook. What could be the problem
21.6 mil Me gusta, 119 comentarios - Jocy Cosplay (@jocy.cosplay) en
All formulas are within the same document.
You might get errors on a shared workbook, like the unreadable content
We address some of the solutions to these shared excel files issues. One common reason for excel formulas not working or calculating is that the calculation options in excel may be set to manual instead of automatic This means that the workbook won’t automatically update when changes are made to the data or formulas. I created a shared excel with several tables that use formulas to show results
When i open the file i can see the formula calculations working correctly but some of my colleagues cannot. Excel formula not working correctly, it returns an error or a wrong result This section provides a summary of the most common mistakes people make when creating formulas in excel and solutions to fix them Match all opening and closing parentheses in a formula.
If you’ve ever felt like excel tables are sabotaging your formulas, you’re not alone
There’s a fix, and it’s simpler than you might think. Using these steps, users can systematically troubleshoot and correct the formula to achieve the desired results. One sheet is a template that pulls data from 3 other sheets through a number of array formulas This data that is pulled is dependent upon the data entered in the first sheet/template
