Open excel File in A1 Cell

can't you just go back to A1 when you save. You just have to press ctrl-home just before click the disc or ctrl-s.

Always, before saving your large file, click on Edit, Go To. In the Go To dialog box, type A1 in the Reference type box and hit Enter. You are in cell A1. Save your file.

Rather simple really.

Step 1, record a macro that does what you want to happen when you open the workbook.
in your case, select a certain worksheet and go to A1...

Step 2, make this macro run when the workbook is opened: here's how

1. On the Tools menu, point to Macro and then click Visual Basic Editor.
2. In the Project Explorer window, right-click the ThisWorkbook object and then click View Code on the shortcut menu.
3. In the Object list above the Code window, select Workbook. This will automatically create an empty procedure for the Open event.
4. Copy paste the code from your previously recorded macro in the sub for the Open event.

now every time this workbook is opened, the macro will be executed.

Press the control key and Home together, then resave the file. Excel remembers the cursor position at save, this applies to every worksheet. If you want every worksheet to be at the Home position - cell A1, then got to each worksheet and use cntl+home.
Note that to shift between sheets with the keyboard you can cntl+Page Up (Right tot Left) or Page Down (Left to Right).