I hope this information can help some of you in beating this annoying bug in Excel. I saved and re-opend the file on two different computers (Vista an WinXp) in Excel2010 and the formatting DID NOT CHANGE !! After deleting the "bastard" styles, I re-applied all my desired cell-styles and formatting and the style selection Box remained clean of unwanted styles. These new styles appear in the top of the Style-selection Box and the name(s) look like the default Style.īy removing these "new" style formats (right mouse click) in the corrupted file, all connected cells fall back to the default Style. I think the origin of the problem lies in the fact that by applying your own customized cell-formatting Excel (somtimes?) creates "new" styles based on the original "General" Style-format. When I go to print, they do not appear on print preview and do not appear when printed out. As the title suggests, I have an excel spreadsheet that include inserted pictures and dialogue boxes. I tried copy-paste into a new worksheet, but after re-applying my desired cell-formatting the problem continued. Select the area you want to print then go to 'Page Layout' in the top menu, then click 'Print Area', then 'Set Print Area'. I had a problem in Excel2010 with "general" format changing to "date" or "currency" format. This may not be the cause of your post but it is related. The older version has a smaller capacity for styles than the new. Our organisation has to provide excel files to users of older versions and when they save out to the older version some of the styles get dropped. So the macro had to cycle through every cell to build a list of used styles. This takes a bit longer because there is no record in excel of which styles have been used except in each cell. So I made another version of the macro to remove the unused styles. I found and modified a macro to remove all of the styles and the problem went away, but then so did some of the formatting. I was copying quite a few files into one when I got an error telling me I could not paste.Īfter much googling I found that the problem was the number of styles exceeded the capacity and it would not paste any data at all.
![text disappears in excel 2010 text disappears in excel 2010](https://www.exceltip.com/wp-content/uploads/2014/08/img32.jpg)
All of the styles in the source file were being copied into the destination file, even if they were not in use.
![text disappears in excel 2010 text disappears in excel 2010](https://cdn.extendoffice.com/images/stories/doc-excel/identify-missing-numbers/doc-identify-missing-numbers-9.png)
I came across something related to this a while back when copying the contents of one excel file to another. The solution is to transfer your data from the current workbook to a new workbook and then see if the problem occurs in the new one. The other possible cause is that the workbook file is corrupted in some manner. This is particularly true with colors and conditional formatting.
![text disappears in excel 2010 text disappears in excel 2010](https://cdn.extendoffice.com/images/stories/doc-excel/identify-missing-numbers/doc-identify-missing-numbers-05.png)
If you are saving it in the older Excel 97-2003 format, then it is possible that the losses you are seeing are due to the formatting not being supported in the older format. As far as we can tell, the problem could be due to two different potential causes.įirst, you should make sure that your workbook is being saved in native Excel 2007/2010 format. There is no acknowledgement from Microsoft that it is a known problem (at least, as far as we can find), but it apparently is a problem shared by many people. They can't find a pattern, and were wondering if this is a known problem.
![text disappears in excel 2010 text disappears in excel 2010](https://images.tips.net/S22/Figs/T6125F1.png)
They save and close the workbook the next time they open it, the formatting is gone. The formatting includes fonts, colors, shading, borders, number formats, and so on. Several of them have intermittent problems with losing formatting. I have NO IDEA what's causing this nor have I seen anything like this before.Jennifer is in an office with ten people, all using Excel 2007. Strangely enough, if I put the AA5 formula in almost any other cell, this whole disappearing routine doesn't happen! (I'm not anxious to do this because of the nature and complexity of the spreadsheet.) However in cell AA5 the constant 100 appears and the formula is gone. if I change the value in cell Z10, this changes the value in AA10 which in turn changes the value in AA20, say to 200. Second and most importantly, when the value of the SUM() (cell AA20) changes the entire formula in AA5 disappears, to be replaced with whatever the last value the AA5 formula had!įor example, initial condition is that AA20 = AA5 = 100. blah blah blah." However there is no other indication of a circular reference in this cell or on the worksheet and there's nothing I can track down Cell AA5 has a range name of "TOT_AA"įirst off, when I do an EVALUATE FORMULA on AA5 it says "This is a circular reference and may not evaluate. In AA5,however, I have another formula, =+AA20 that is, this cell references the cell that contains the SUM. A typical example is column AA where rows AA10-AA17 contain values, each of which is generated by some formula (e.g., formula in AA10: =y10 * z10).Ĭell AA 20 contains the formula =SUM(AA10:AA17). In my Excel 2010 spreadsheet I have several places where the following problem crops up. HELP! This is an odd problem, please stay with me as it's hard to explain.