Why are my functions not working on multiple sheets in my Excel workbook?
- Ensure your function is referencing the exact sheet and cell it needs.
- Check the syntax of your function using the Excel help menu.
- Check that the sheet names and cell references you are using in your function are correct.
- Save and close the workbook, then reopen it to make sure your changes are saved correctly.
- If the functions still aren’t working, try resetting Excel to its default settings.
- Finally, try uninstalling and reinstalling Excel.