ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Excel (https://www.excelbanter.com/excel-discussion-misc-queries/102483-opening-excel.html)

Mike

Opening Excel
 
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

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.

Mike wrote:

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

Jim Rech

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
"Mike" wrote in message
...
|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?



Mike

Opening Excel
 
There are no macros associated with this spreadsheet.

"Dave Peterson" wrote:

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.

Mike wrote:

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


Mike

Opening Excel
 
There are no macros associated with this worksheet.

"Jim Rech" wrote:

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
"Mike" wrote in message
...
|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

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.

Mike wrote:

There are no macros associated with this spreadsheet.

"Dave Peterson" wrote:

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.

Mike wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com