Excel Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2504883%22%20slang%3D%22en-US%22%3EExcel%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2504883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello!%20I%20have%20a%20couple%20of%20questions%20about%20Excel%20I%20am%20hoping%20someone%20could%20help%20me%20with%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%3E%3CSPAN%3EI%20have%20been%20having%20trouble%20sharing%20an%20Excel%20file%20on%20OneDrive.%20Users%20(even%20I%2C%20who%20created%20the%20file)%20have%20to%20first%20create%20a%20new%20copy%20before%20editing.%20How%20can%20multiple%20users%20have%20access%20to%20the%20Excel%20file%20without%26nbsp%3Bhaving%20to%26nbsp%3Bmake%26nbsp%3Bcopies%20to%20make%20changes%3F%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3BNote%3A%20this%20is%20an%20intermittent%20problem.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CSPAN%3EI%20have%20a%20database%20on%20Excel%20that%20lives%20in%20OneDrive.%20It%20includes%20a%20lot%20of%20entries%20and%20pictures%20and%20I%20believe%20the%20size%20and%20the%20images%20are%26nbsp%3Bmaking%20it%26nbsp%3Bslow%20to%26nbsp%3Bpull%20up.%20Is%20there%20a%20way%20to%20make%20it%20upload%20faster%3F%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%20in%20advance%20for%20any%20help!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2504883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2505533%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092584%22%20target%3D%22_blank%22%3E%40ZJYGO%3C%2FA%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CFONT%20size%3D%224%22%3EFirst%20Sign%20in%20to%20%3CSTRONG%3EO%3C%2FSTRONG%3EneDrive.%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%224%22%3EThen%20find%20%26amp%3B%20hit%20the%20folder%20contains%20the%20WB%20you%20want%20to%20share.%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22ocpRunInHead%22%3EN.B.%3C%2FSPAN%3E%26nbsp%3B%20%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CFONT%20size%3D%224%22%3ERemember%20other%20person%20will%20be%20able%20to%20access%20everything%20from%20the%20folder.%20so%20to%26nbsp%3B%3C%2FFONT%3E%3CFONT%20size%3D%224%22%3Ekeep%20the%20specific%20WB%20private%20better%20create%20a%20separate%20folder%20for%20the%20WB%20you%20want%20to%20share.%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%224%22%3ENow%20hit%20the%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3E%3CSTRONG%3ES%3C%2FSTRONG%3Ehare%20command%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EI%3C%2FSTRONG%3Envite%20the%20person%20with%20whom%20you%20want%20to%20share%20the%20WB.%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%224%22%3EAgain%20hit%20the%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3E%3CSTRONG%3ES%3C%2FSTRONG%3Ehare%20command.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%224%22%3E%26nbsp%3BNow%20if%20you%20feel%20open%20WB.%26nbsp%3B%3C%2FFONT%3E%3CFONT%20size%3D%224%22%3EAfter%20the%20person%20%3CEM%3Ehit%20the%20link%20you%20sent%20him%3C%2FEM%3E%20%26amp%3B%20start%20working%2C%20you%20can%20find%20the%20changes%20that%20person%20has%20made.%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22ocpRunInHead%22%3EN.B.%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20size%3D%224%22%3EExcel%20only%20keeps%20the%20last%20changes%20made%20by%20either%20host%20or%20others.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

1 Reply

@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.