Saving Issues

asjmoron

Board Regular
Joined
Apr 26, 2016
Messages
92
Hi all,

Im not sure if this possible but any ideas would be amazing!

I have a sheet that is used by a colleague of mine and she keeps accidently saving it in random places which breaks all of the external refs. Is there a way to set the sheet to only be able to be saved in one location?

Im not holding my breath on this one...

Thanks!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,560
Office Version
2019
Platform
Windows
Record a macro that saves the file to the correct location. Then instruct your co-worker on how to save using the macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,013
Messages
5,466,022
Members
406,461
Latest member
Garrus

This Week's Hot Topics

Top