Excel Misc >> Opening Excel
Excel will open in the way it was previously saved--unless there's a helpful
macro that's running when you open the file.
Can you open that file with macros disabled to test it?
If that works, it's time to look for that helpful macro.
>
> I have a spreadsheet that always opens to a cell in Column DX. I thought
> Excel would reopen afile to the cell that was last saved.
>
> How can I have the spreadsheet open to the last cell that used and not
> always to Column DX?
Excel Misc >> Opening Excel
>> I thought Excel would reopen afile to the cell that was last saved.
It does, unless something intervenes. Try disabling macros to see if the
problem goes away. If so you can then modify or delete the macro..
--
Jim
|I have a spreadsheet that always opens to a cell in Column DX. I thought
| Excel would reopen afile to the cell that was last saved.
|
| How can I have the spreadsheet open to the last cell that used and not
| always to Column DX?
Excel Misc >> Opening Excel
There are no macros associated with this spreadsheet.
> Excel will open in the way it was previously saved--unless there's a helpful
> macro that's running when you open the file.
>
> Can you open that file with macros disabled to test it?
>
> If that works, it's time to look for that helpful macro.
>
> >
> > I have a spreadsheet that always opens to a cell in Column DX. I thought
> > Excel would reopen afile to the cell that was last saved.
> >
> > How can I have the spreadsheet open to the last cell that used and not
> > always to Column DX?
>
> --
>
> Dave Peterson
>
Excel Misc >> Opening Excel
There are no macros associated with this worksheet.
> >> I thought Excel would reopen afile to the cell that was last saved.
>
> It does, unless something intervenes. Try disabling macros to see if the
> problem goes away. If so you can then modify or delete the macro..
>
>
> --
> Jim
> |I have a spreadsheet that always opens to a cell in Column DX. I thought
> | Excel would reopen afile to the cell that was last saved.
> |
> | How can I have the spreadsheet open to the last cell that used and not
> | always to Column DX?
>
>
>
Excel Misc >> Opening Excel
Any chance you have a macro in a different workbook that's running?
Try closing excel
then
windows start button|run
type:
excel /safe
and file|open your workbook
Starting excel in safe mode will not allow any macro to run.
>
> There are no macros associated with this spreadsheet.
>
>
> > Excel will open in the way it was previously saved--unless there's a helpful
> > macro that's running when you open the file.
> >
> > Can you open that file with macros disabled to test it?
> >
> > If that works, it's time to look for that helpful macro.
> >
> > >
> > > I have a spreadsheet that always opens to a cell in Column DX. I thought
> > > Excel would reopen afile to the cell that was last saved.
> > >
> > > How can I have the spreadsheet open to the last cell that used and not
> > > always to Column DX?
> >
> > --
> >
> > Dave Peterson
> >