Excel Question

[ZJYGO]

Hello! I have a couple of questions about Excel I am hoping someone could help me with:

1. I have been having trouble sharing an Excel file on OneDrive. Users (even I, who created the file) have to first create a new copy before editing. How can multiple users have access to the Excel file without having to make copies to make changes? Note: this is an intermittent problem.

2. I have a database on Excel that lives in OneDrive. It includes a lot of entries and pictures and I believe the size and the images are making it slow to pull up. Is there a way to make it upload faster? 

Thank you in advance for any help!

[#2]

@ZJYGO 

• First Sign in to OneDrive.
• Then find & hit the folder contains the WB you want to share.

N.B.   

• Remember other person will be able to access everything from the folder. so to keep the specific WB private better create a separate folder for the WB you want to share.
• Now hit the Share command.
• Invite the person with whom you want to share the WB.
• Again hit the Share command.
•  Now if you feel open WB. After the person hit the link you sent him & start working, you can find the changes that person has made.

N.B. Excel only keeps the last changes made by either host or others. 

• As far as size is concern allowed file size is 15 GB. But recently came across one article that it has been increased to 100 GB,,, better check it.