We have a spreadsheet with many worksheets that represent each of our customers and a main sheet that was created as a starting point to get to the other sheets more rapidly. The main sheet basically consists of shapes (Rectangles) with the name of the customer and the shape is filled with a graduated color, and a hyperlink to the other worksheets. This was done with Excel 2003 by someone who is no longer with our company. Last week I upgraded our Call Center with Office 2007 and now some of the shapes don't appear until you Right Click on them, however, if you place the mouse pointer on the blank area and click, the hyperlink will take you to the correct sheet. If you right click on the blank position the shape is visible and if you left click it will take you to the appropriate sheet but if you go back to the main sheet, that shape disappears again. It is always the same shapes that do not appear. I have looked at the formatting of the shapes and text compared to the ones that are always visible and I cannot find any difference. Any Ideas?
Bookmarks