We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x
Private

Multiple Users Working on the same Excel File (having Macro) in Excel 365

High Priority
32 Views
Last Modified: 2020-06-24
Hi Experts,

Kindly Advise, how multiple users can work simultaneously on the same file (containing VBA macro).
We are using Office 365 (or Microsoft 365).
What is the Safest method to do so ?
Whether everyone will be able to use VBA Macro's at the same time in such a scenario ?
Whether Google Drive or One Drive permits the use of VBA Macros ?

Regards
Kanwaljit
Comment
Watch Question

Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Office 365 has this feature

Share and collaborate with Excel for the web

This is better than the old method of sharing workbooks, but I still don't think Excel is the best application for shared working.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Well is viable via a feature called co-authoring : https://smallbusiness.chron.com/make-excel-allow-multiple-users-71302.html
But you should consider that Excel is just smart spreadsheet not a database.

Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
@ Roy Cox,
AFAIK, Office for the Web does not support macros. Does it !!
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
Thanks John,
What I understood from the article is that we need to use One Drive for this. I will try that. But I am not sure about the macros.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Again as said ...Excel is not a good candidate for multi users....when it grows to a size it becomes heavy and cumbersome..
You should consider switching to a database.

Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
But you should consider that Excel is just smart spreadsheet not a database
Agree 100%. No arguments on that.
I wish there could be a database which I can use as back end in conjunction with Excel 365 at the front. I wish as we are able to manipulate Excel to do whatever we require at the user level and don't have to spend a big chunk on the software front.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Why not use database for FE and BE
Access is probably the most flexible solution ....you start it locally...you extend it to network and if you want cloud then with a "mere" Database engine switch it gets Cloud all the way...and above all is much much more powerful in probably every single aspect except  charts and some Microsoft clever marketing-alike wizards
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
Kindly suggest some article or video or guide on how to start doing it.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
Thanks John,

Access 2002 Developer's Handbook Set by Paul Litwin (2002-01-23) Paperback –  January 1, 1849

That really seems some book. Even before Microsoft :)
But It seems that is too costly at $985
I request for some better deal.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Office 365 supports macros if you open it from your desktop, how well it works with multiple users I do not know.
Software & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
I wonder whether there is any change in Access since 2002 as compared with 2020 version ?
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
There are changes but more on the cosmetic side (Ribbon)
95% is still the same. (even more)
 
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
Thanks John,
I will try to find those books within my budget, but definitely I will check that till you suggest any updated or better version of those books.
Kanwaljit Singh DhunnaSelf Employed

Author

Commented:
Thanks John,
I will post another question regarding the use of Macros.
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Welcome to Access...you will discover a whole new great world.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
https://www.amazon.com/Access-Developers-Handbook-Litwin-2002-01-23/dp/B01JXQFRMC

This link is for a used version, it isn't available elsewhere
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
If you store the file on OneDrive, you get the co-authoring benefit.

If you open the file using desktop Excel (Mac or Windows), macros can be used.

If you store the file on OneDrive and open it with desktop Excel, you should be able to enjoy both co-authoring and macros.

There was extensive discussion about how to handle macros with co-authoring at the 2017 Excel MVP Summit. Event macros run locally (just for the one user), but the result of other macros propagates to everyone who has the file open. Note that everybody who opens the file should be using Microsoft 365 (formerly called Office 365) or Excel 2019.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.