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 What could be the problem 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.
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 I've been the only one using this for that past few years, but i need to allow other users to access the workbook. Are you frustrated with your lost data in a shared workbook in excel
OPEN
