Error found in an excel file with marco

All users open the file with the error warning except the author of this file. Need help, how to resolve?

ImageImage

Answer
Answer

Without the file we can only guess what happens ... maybe a named range using a (invalid) formula and or UDF?

A user should open the file, save it, close and reopen. The error should be gone.

Send that file to the author and he should check if anything work properly. I bet he knows what is removed.

If you need further help:

Tell him he should create a sample file with that removed thing.
Zip the file, upload it to your onedrive and post the download link here.

Then we can reproduce the issue and maybe find a workaround.

Andreas.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 44 Applies to: