View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Help needed in hanging the default file location for Excel and Word

I first started using Office 4.3 (?) when it had Word 2.0 in
1993. I have always created my own folder in c:\office documents
to store my work products. I have never used the Documents area
that Windows created.

I am now using Office 365 MSO (16.0.11126.20192) 32-bit in a
Windows 10 Pro 1809 setup. I finally decided to utilize the
Documents area. So I moved all my Word and Excel files to the
Documents folder: C:\Users\Kirk\Documents. Everything search
confirms that all the .docx and .xlsx files are there.

I now have a problem. When I go into Word or Excel and try to
bring up a file, it rejects my request, saying that it can't find
my old default location. When I use the Help function in Excel,
it misleads by telling me to go: File, Options, General, Info
Path Options, more options. However, there is NO Info Path
Options choice available in either Excel or Word. When I go:
File, Options, Save I am presented with a chance to set the
Default Local file location. I change that and click Okay, but
the next time I try to get that file, it says that it can't find
it, referring to the old file location. The error message doesn't
tell me how to change the default location of moved files.

When I try to open a file that I've changed the default location
on, it rejects me. I can Browse to that file at
C:\Users\Kirk\Documents and open it, and I can look at the File,
Options, Save, default local file location, and it says that is
C:\Users\Kirk\Documents. But that new location doesn't "take."

What am I doing wrong? Is there a way to change the file
location so that I can open my files without having to browse to
them each time?

Thanks in advance for any help.


Excel stores the full path to the files on its Recent list; - since you've
moved those file to a different path, Excel can't find them in the 'stored'
path.

You need to Browse the 1st time you open any of those files so Excel stores the
new path for each one!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion