Comments

[andyburgess]

Hi

We have a spreadsheet that is shared across our company. We have a variety of version of Excel, from 2000, 2003, XP and 2007.

When one of the users makes a comment in a cell, it will show everytime someone else opens it. My view settings are set to comment indicator only, but still they appear. It does this on mine (03) and everyone elses.

The person whose comments always show is running 2000.

Any ideas greatly appreciated

Thanks

Andy

 

[Tuta]

Convince the bigwigs to up/downgrade to the same version of Excel across the board. I know, easier said than done...

 

[andyburgess]

I'd have more chance of getting blood from a stone!! Thank you for the quick reply.

It never used to do it though and has only just started.

Thanks

 

[arkusM]

I don't have an answer for you but a similiar experiance. I try to leave my spreadsheet set to manual calc. I have repeatly found that when someone opens my sheet, that is set to manual calc, and they last had a sheet set to autocalc, my sheet switches to autocalc. I think this option does not fully reside in either the worksheet or shell program.

For more Excel oddities see: http://spreadsheetpage.com/index.php/oddity/C38/