I have an Excel workbook with several spreadsheets that I have been using for over a year to track equipment orders. All of a sudden after adding more equipment item lines the Font and Fill Color menu in the toolbar have "requenced", they now have what appears to be a random organization and almost all my font and fill colors have changed. The spreadsheet this started happening in is only 425 lines x 30 columns and none of the other spreadsheets in the workbook are much larger and most are smaller.
I can go back to the most recent file before I added the line items and the font and fill menus are standard. As soon as I add the 6th line, this starts again.
I am not using any color macros for cell color or fill, only using the menu to highlight specific cells.
I have Excel2007, but when I open a file with the "reorganized" font and fill menus the colors in the spreadsheet are still "reorganized". I really do not want to start using 2007 right now if I can avoid it.
I can send the file to anyone who wants to see it.
Anyone got an idea what is happening and how to fix it. I plan on having to add several hundred lines in the future.
Bookmarks