This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
| Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked<br> workbooks, characters beyond the 255-character limit cannot be returned. |
|---|
I could not locate any formulae in my worksheets, pls advise how do i find these formulae.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
As per my understanding.
You are linking an closed file> then how do you save the file format?
Because if its not compatible then you should get the compatibility error or you are not updating the link properly.
Keep Eye on your TIME, Not on your WATCH.
Check the file format if you are saving properly.
Its like using adavcne forumla in excel 2007 and saving it in excel 2003 file format.
And that is how it returns an error for you!
Click on forumlas > name manager and check if the label has got reference to any other name or check in data> connections> connections and remove links for sources.
This response does not make any sense. How did you identify where the errors were that needed to be fixed if you could not find any links to external files in your workbook?