function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AlexhoranAlexhoran 

Excel Connector and Shared Workbooks

I have a workbook that uses information from SFDC to perform certain calculations. I need to have multiple people be able to access the workbook at the same time. In order to do this I want to Enable the Shared Workbook functionality of Excel (I am using 2003). However when I enable this feature the automatic update functionality of the SFDC Excel Connector is disabled. And in fact I cannot even perform a manual update.

Has anyone else seen this and should I be able to use the Excel Connector in a shared workbook?

Thanks
Ron HessRon Hess
I'll bet sharing the workbook locks the cells , ranges or worksheets.
or "protects" the worksheet
i'll have to do some more research on where this fails.

thanks for pointing this out, i was not aware of an issue.
AlexhAlexh
No problem - this is a feature/functionality I would find very useful so I would be very happy to beta test any solutions you develop (if you end up trying to resolve this).