Make Excel default save a worksheet to a different location than where the file was opened?

Make Excel default save a worksheet to a different location than where the
file was opened?

I am not nearly as computer literate as most people on this site, so
please keep it simple. I have an excel file with two worksheets in it. I
want to make one worksheet default save as a PDF in a different location
on the server than where I opened the file. I have tried going into Save
Options and changing the default location but that did not help. Microsoft
technicians think it may be a setting on the network that needs to be
change. Thanks!