Whenever I save a file in Excel and reopen it, it reopens at the exact location of where I saved it. So, for example, if I saved it while looking deep in the file at Column AV/Row 232, it will open at that location and not at Column A/Row 1. This is how Excel has always saved files, to my knowledge.
However, I work with some really dense people, and they don't realize that when you open the file, you can scroll to the left or up. So I'm always having people calling me and telling me I didn't send them the whole file. Short of always returning to Column A/Row 1 before saving, is there any way I can guaruntee if will open up at Column A/Row 1 no matter where in the file I am when I save it?
This also applies to multiple sheet documents. If I save a file with 3 sheets, for example, and am on the second sheet when I save it, it will reopen in the second sheet and not in the first. Is there an option to have it always open on the first sheet?