Shared Workbook

Evagrius Ponticus

Well-known Member
Joined
May 24, 2007
Messages
1,470
Hello!

I have a workbook with around 50 or so pages of code. Many sheets are veryhidden but can be unhidden based on user interaction. I also have shapes and Userforms in the workbook.

I am having a tough time making this workbook a shared workbook. Do I have any options? Thank You!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Why would you want to ruin your workbook by making it a Shared Workbook?
 

Evagrius Ponticus

Well-known Member
Joined
May 24, 2007
Messages
1,470
HA! I knew it Rorya! Your comment now convinces me that it would be a mistake. My boss asked me to find a "solution." The only think I can think of is an Access DB - or maybe create a data only shared worbook and somehow import the data into the programmed workbook. What do you think?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
It depends exactly what you are doing, but if you can use a database for the source data then I would probably do that. Excel does not really handle multi-user editing very well (the 2010 web apps are supposed to be better, but the functionality is not as good).
 

Evagrius Ponticus

Well-known Member
Joined
May 24, 2007
Messages
1,470

ADVERTISEMENT

Rorya - one last question. Do you suggest that I use Access for the source data and import that data into Excel? Is that a solid strategy.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Again, it depends on what you are doing. It may be simplest to have one or more queries linking to your access data and then report off that, or you may want pivot tables linked to queries in the DB, or you may want to use VBA and ADO to retrieve the data you need for a particular report, or... :)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,311
Members
409,862
Latest member
lbisacca
Top