ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Book1.XLS replace by old file name (https://www.excelbanter.com/excel-discussion-misc-queries/232986-book1-xls-replace-old-file-name.html)

Cowboyfan

Book1.XLS replace by old file name
 
Whenever I open a new Excel Worksheet, it contains the name of an old file -
instead of Book1 -- How do I correct?

Dave Peterson

Book1.XLS replace by old file name
 
I'd look for that file in your xlstart folder and either delete it or move it to
where it belongs.

Find an empty cell in that workbook (any worksheet)
type this in that cell:
=cell("Filename",a1)

That should give you a hint where this file is located.

Cowboyfan wrote:

Whenever I open a new Excel Worksheet, it contains the name of an old file -
instead of Book1 -- How do I correct?


--

Dave Peterson

Cowboyfan

Book1.XLS replace by old file name
 
AWESOME! It worked.....Thanks

"Cowboyfan" wrote:

Whenever I open a new Excel Worksheet, it contains the name of an old file -
instead of Book1 -- How do I correct?



All times are GMT +1. The time now is 02:40 PM.

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