Forum Discussion
Why do I keep getting a pesky formula error message?
- Mar 05, 2024
Inquire add-in is not available for Excel on Mac, so far I know.
let's explore some additional troubleshooting steps to address the persistent formula error messages:
- Check for Data Types: Ensure that the data types in your cells are consistent with the formulas you're using. For example, if you're performing calculations on numbers, make sure that the cells containing those numbers are formatted as numbers and not as text.
- Review Formula Auditing Tools: Excel for Mac includes built-in tools for auditing formulas. You can use features like "Trace Precedents" and "Trace Dependents" to identify any cells that are influencing or influenced by the formulas in question. This can help you pinpoint the source of the errors more accurately.
- Evaluate Formulas: Use the "Evaluate Formula" feature to step through your formulas and see the intermediate results at each stage of calculation. This can help identify where the errors are occurring and why.
- Use Error Checking: Excel for Mac includes error checking features that can help identify and resolve formula errors. Go to the "Formulas" tab in the ribbon and click on "Error Checking" to see if there are any errors detected in your workbook.
- Recreate Formulas: If you're still unable to identify the source of the formula errors, consider recreating the formulas from scratch. Copy the data to a new worksheet and rebuild the formulas one by one, checking for errors as you go.
By systematically going through these additional troubleshooting steps, you may be able to identify and resolve the formula error messages in your workbook. If you continue to experience difficulties, Welcome to your Excel discussion space!. My knowledge of Mac is limited.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
NikolinoDE thanks for the quick response. I ran thru all your suggestions except the one for the COM add-in. Using Excel for Mac, I can't get that one....apparently it's not available.
I deleted my 'report' tabs one at a time just to see if the error messages would stop, but no luck going that way. I use a hidden tab where most of the calculations that appear in the 'report' tabs are displayed, but in deleting that tab, everything is an error. I also checked for hidden links and error messages (#REF) in those links. I found a few; deleted them, but the error message continues.
Stumped still, but I certainly do appreciate your expertise.
Rick
Inquire add-in is not available for Excel on Mac, so far I know.
let's explore some additional troubleshooting steps to address the persistent formula error messages:
- Check for Data Types: Ensure that the data types in your cells are consistent with the formulas you're using. For example, if you're performing calculations on numbers, make sure that the cells containing those numbers are formatted as numbers and not as text.
- Review Formula Auditing Tools: Excel for Mac includes built-in tools for auditing formulas. You can use features like "Trace Precedents" and "Trace Dependents" to identify any cells that are influencing or influenced by the formulas in question. This can help you pinpoint the source of the errors more accurately.
- Evaluate Formulas: Use the "Evaluate Formula" feature to step through your formulas and see the intermediate results at each stage of calculation. This can help identify where the errors are occurring and why.
- Use Error Checking: Excel for Mac includes error checking features that can help identify and resolve formula errors. Go to the "Formulas" tab in the ribbon and click on "Error Checking" to see if there are any errors detected in your workbook.
- Recreate Formulas: If you're still unable to identify the source of the formula errors, consider recreating the formulas from scratch. Copy the data to a new worksheet and rebuild the formulas one by one, checking for errors as you go.
By systematically going through these additional troubleshooting steps, you may be able to identify and resolve the formula error messages in your workbook. If you continue to experience difficulties, Welcome to your Excel discussion space!. My knowledge of Mac is limited.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- rjoberhoferMar 05, 2024Brass ContributorNikolinoDE Thanks for your persistence. I think it would be impossible for me to recreate all the formulas, as there are literally thousands. I've tried the formula audits; Tracing dependents and precedents isn't practical either, as I would have to know which formula or reference is giving me the error. Again, there are thousands, and the formula error tracking does not identify any specific formulas or cells that are creating the error.
Would you know of any other superstar Excel user who, for a fee, would take my file, open it in a PC environment to use the other tools you mentioned to find the issue? (payable via Venmo when the issue is resolved)
Rick- Detlef_LewinMar 07, 2024Silver Contributor
It seems you are not really looking for a solution.
You do not show the "pesky error message".
You do not provide the workbook.
So the helpers have no way of knowing what is going wrong.
- rjoberhoferMar 07, 2024Brass ContributorThe file is 109mb in size and won't fit in the upload portal. My original question asked for ideas on things I should look for, other than the numerous error checking routines I already did.
There is a gold contributor who has the file now who's taking a look at it. Hopefully he can figure it out.
thanks for the reply.