This is a strange event. I exported a table from Access 2002 to an Excel spreadsheet and created a pivot table on a new sheet in the book from the data. Then I tried to format some of the cells. Clicking "Format cells" from the context menu or from the main toolbar does not open the format window. In fact nothing happens at all. If I apply an auto-format to the data or the pivot table I can then format individual or groups of cells. Are the cells somehow "locked" to prevent formatting? The worksheets and workbook are not protected.

I am using Office 2000 and WinXP.

Thanks for the help