Hi Madsalmon,

I recently reloaded office 07. Now an excel spreadsheet I am working on has
(shared) and (compatabilty mode) in the title bar. I can't find any
explanation of what this means. Is it possibly causing the problems I am
experiencing eg most functions under 'insert' greyed out eg pivot tables etc.

Compatibility mode is what Excel 2007 enters as soon as you open an "old" Excel
file. It ensures your file stays within the old fileformats boundaries
regarding for example the number of rows and columns.

Shared means the workbook is in shared mode and theoretically more than one
user can edit the file (which I do not recommend you to do!).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com