sharing a workbook on a server

[CoolBreeze]

When you go to open a workbook that someone else is using in Excel 2003, it says "workbook in use by XXXXX". We've just upgraded to Excel 2007 (yay we're only 4 years behind the times now). I wonder, is there a way for two people open the same workbook at the same time?

Or is this like crossing the streams in Ghost Busters? i.e. it's never gonna happen.

thanks!

 

[Derek Brown]

You can 'share' workbooks but personally I find that they are more trouble than their worth. See 'Shared Workbook' in Excel Help and in particular check the 'limitations'.
I don't know if a workbook can be shared between different versions of Excel but if they can I would certainly advise against doing it.

 

[Ruddles]

It should offer you the option of opening as read-only. Is that no use?

 

[GlennUK]

Avoid sharing workbooks, if at all possible. They are very unstable, and will get corrupted.

See this for more info:

http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

 

[Ruddles]

Shared workbooks - ugh!

 

[GlennUK]

Shared workbooks - ugh!

I couldn't have put it better myself