Share Workbook

[gmazza76]

Good Evening,

I have been using VB in a workbook recently and have noticed that the workbook has suddenly stopped me trying to make it a SHARED Workbook.

Is anyone aware of a way of stopping this happening?

Many Thanks
Gavin

 

[Derek Brown]

I don't have an answer for you as Shared workbooks have many limitations - for example, Tables/Lists I believe cannot be used so if you added a table (if you are using Excel 2007/2010) that could be the cause.
I always recommend avoiding the use of shared workbooks - I have found that they are more trouble than they are worth.
As an alternative, I provide identical workbooks to users and have used VBA to merge the data into a Master workbook.
Some useful links that may help:
http://blog.contextures.com/archives...ooks-in-excel/
http://office.microsoft.com/en-us/ex...005201080.aspx
http://support.microsoft.com/kb/302911/en-us
http://office.microsoft.com/en-us/ex...001013057.aspx

 

[gmazza76]

Many Thanks

Only 1 of the links work ( 3rd One ), but i think i understand how to fix this from now on.

Gav

 

[Derek Brown]

Sorry, I don't know why that is.
Let me try again:
http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/
http://office.microsoft.com/en-us/e...vailable-in-shared-workbooks-HP005201080.aspx
http://support.microsoft.com/kb/302911/en-us
http://office.microsoft.com/en-us/excel-help/administration-of-shared-workbooks-HA001013057.aspx

Just tried them from the above links and they work for me.