Calibri font missing message

Whenever I open a spreadsheet that I used on Numbers for iOS before updating to numbers 2.0, I now get a message saying that the don't Calibri is missing and that the spreadsheet may look different.


I tried checking every cell to see where I used Calibri and I cannot find any.


I closed the spreadsheet and reopened it and continue to get this message each time I open the file.


Any ideas as to how I can find where Calibri is used or how to get this message to stop appearing?


Is there an automatic way to convert any place it thinks is Calibri used to another font?


Thank you!

Numbers 2.0 for iOS.-OTHER, iOS 7.0.2

Posted on Oct 22, 2013 7:35 PM

Reply
22 replies

Oct 23, 2013 4:35 PM in response to don-awalt

I haven't downgraded to the newest version, so I don't know specifics, but the fallacy in your thinking with regards to Select All, is that it only works in the main, printable part of the document, while the troublesome font may also be used in the document for the definition of an unused style, or an alternate page template that is available for inserting.

Oct 23, 2013 4:46 PM in response to Jeff Shenk

How would I find those? I went so far as to copy everything, create a backup file, delete everything in the copy file and then close it and open it again. I still get the error message. How could I change something at the point to remove Calibri?


On a positive note, on one spreadsheet I was messaging around and it just seemed to stop eventually, without me realizing if or what I changed. Unfortunately I have no idea what caused it to stop so I can't replicate it.

Oct 24, 2013 4:41 AM in response to GeoffStern

Since Calibri is a default font in Microsoft Office, it is easy to get this kind of thing if things that were created in Word or Excel are imported into Numbers or Pages. It is probably easier to just install Calibri than to hunt down where it might be hidden in your document. You can get it free from an Office trial (extract it from the installer with Pacifist, or install the trial and then delete the applications, but keep the fonts).

Oct 24, 2013 5:04 AM in response to Jeff Shenk

Thanks. I don't think I could do that though on the iPad. And also when I share the spreadsheet with other iPad users, they would then have the same issue. I need a way to find where it thinks Calibri is used and then find a way to make it realize that Calibri isn't there at all. I have changed every font and no Calibri. I have deleted everything in that particular spreadsheet and still get the error when opening the blank sheet. So I think you are right that it is used in some styling somewhere as a setting. But how can I change that even in the blank sheet?

Oct 25, 2013 3:48 AM in response to GeoffStern

I am having the same problem in both Pages and Numbers (iPad). Since I updated both several days ago every document or spreadsheet tells me my document may look different because the calibri font is missing. My documents and spreadsheets have come from Microsoft Word and Excel. I did not get the message before I updated (and the documents are the same). I don't care that the fonts might look different just get rid of the bloody annoying message Apple. I have my songbook in Pages and every time I open a song I go thru the same irritating message. All my Uni class spreadsheets are in Numbers and I have the same frustration. Apple - you know there is a problem - fix it.

Oct 26, 2013 2:57 PM in response to Windowspray

Here's what worked for me. After many hours of trial and error, this was extremely annoying, tedious, and time consuming, but it worked. I have asked Apple to continue to look for another possible solution as it shouldn't be this complicated!


It seemed to me that once a spreadsheet had the error message there was no way to remove the error message from that spreadsheet (ever). I went so far as to duplicate a spreadsheet that contained the error message and select all and hit delete. I then closed and reopened it, and the error was still there. If I created a blank new spreadsheet, it would not contain the error, but if I selected all from the old, copied and pasted into the new spreadsheet, the error would appear when opened. Here's how I proceeded;


1.First, create a blank new spreadsheet.

2. Open the spreasheet with the error.

3. Select one object only, copy and paste into the new blank spreadsheet.

4. Click "spreadsheets" in the top left corner and then reopen it.

5. If the error appears, delete the new spreadsheet and create a new blank sheet. If there is no error, go back to step 2 and repeat with a different object.

6. Go back to the sheet with the error, select the same object that you just copied. Under the table options, turn on table name, change the table font to anything, and then back to the font you wish to use. Turn off the table name again (unless you want to use it, which I didn't in the first place).

7.Copy the object again and paste into the new blank spreadsheet. Click "spreadsheets" in the top left to close and then reopen the sheet to check for the error. For me at this point the error was gone.


I had to do this for EVERY SINGLE opject in my spreadsheet. Each time you find an object with an error, you will have to delete the new one you made and create a new one that is error free. You don't have to start over and copy the objects that you previously copied.

8.Once you have dont this with EACH object and ensured that you can open the new spreadsheet and not get the error message, create a brand new spreadsheet again.

9. Go back to the original spreadsheet that you checked every object and changed the table font. Select All and copy.

10.Paste into the newly created spreadsheet. It should now be error free, even though the original still is error prone.


Repeat all the above steps for every sheet within each workbook, each time you complete checking every object on a given sheet, you can do steps 9 and 10 into the same worksheet that you created after finishing the first sheet.


When you are all done, rename the tabs in the new worksheet to match the original. Then delete the old worksheet (at at least change its name) and rename the new worksheet to the name of the orignal.


You should now have an exact copy of the old error prone worksheet in a new worksheet error free.


Like I said before, it was very time consuming and a tedious, annoying, PITA, but it worked! Each time you open the old error prone worksheet you get the message and have to click done. I hope this works for you in the meantime, while Apple works on a better fix. I'm hoping that my information here will help them discover what might be causing the problem so they can fix it on their end.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Calibri font missing message

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.