REF error on their Excel files (office 365)

Hi,


Users are experiencing REF error on their Excel files, especially those which has many links. 

All is Okay in Office 2007 and 2010.


Any known issue of fix?


Thanks


  • Edited by MGerio Tuesday, July 28, 2015 11:53 PM
July 28th, 2015 11:51pm

Hi MGerio,

Could you tell me if this is a particular file to get #REF! Error?

You said >>All is Okay in Office 2007 and 2010. <<, did you mean you upgrade to 2013 from 2007 and 2010 and the file works fine in Office 2007 and 2010 previously?

You also said >> those which has many links<<, did these links link to external data?

Ideally, Excel shows this error when a formula contains a cell reference that isnt valid. You can refer to this article and check if these methods work for you:
https://support.office.com/en-US/article/Correct-a-REF-error-822C8E46-E610-4D02-BF29-EC4B8C5FF4BE

I suggest you provide a sample file or a screenshot about your issue, you can send it to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 5:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics