Shared Workbook

Evagrius Ponticus

Well-known Member
Joined
May 24, 2007
Messages
1,467
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!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,820
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,467
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
38,820
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,467

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
38,820
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... :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,627
Messages
5,838,444
Members
430,548
Latest member
hh_dh2001

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top