Personal Workbook

[AllisterB]

I need to be able to access my personal workbook whether I am on my laptop or my work system. I store workbook files on Local and Network drives.

I thought this could be done if I store it in One Drive.

Would this work - if so how would I tell Excel that the personal workbook is in One Drive

Thank You

Allister

 

[sykes]

I THINK it'll work, but strongly suggest that you make a copy of your treasured personal workbook first, then you can reinstate if it all ends in tears...

Yes - you can store the personal workbook in another location:
File/Options/Advanced/scroll down to "General" and in the text area "At startup, open all files in: enter the new path.

NB suggest only store the one file in that location, as Excel is being instructed to open ALL files at that location.

 

[alansidman]

crossposted: Access to Personal Workbook [SOLVED]

 

[Fluff]

@AllisterB
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[AllisterB]

i

At the time I posted on Mr Excel I had marked the other posting as solved. I did this because I hadnt got any replies from a huge number of views and I couldnt find out how to deleted the thread.

Thank you

 

[sykes]

...and did my suggestion help?

 

[AllisterB]

Thank you - yes your suggestion was helpful

 

[sykes]

Good, glad it helped. Thanks for letting m know.