Take a look at our
ThinkPads.com HOME PAGE
For those who might want to contribute to the blog, start here: Editors Alley Topic
Then contact Bill with a Private Message

How to force Excel to always open with same spreadsheet?

Talk about "WhatEVER !"..
Post Reply
Message
Author
RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 23841
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

How to force Excel to always open with same spreadsheet?

#1 Post by RealBlackStuff » Sun Jan 15, 2012 2:38 pm

I have an Excel (Office 2003) file inventory.xls that I use on a daily basis.
How can I force Excel to always open with inventory.xls when I click on the Excel icon/link in my (Windows) Start Menu?
I tried entering it in the link's "Properties/Start in:" but that does not work.
Lovely day for a Guinness! (The Real Black Stuff)

Puppy
Senior ThinkPadder
Senior ThinkPadder
Posts: 2821
Joined: Sat Oct 30, 2004 4:52 am
Location: Prague, Czech Republic

Re: How to force Excel to always open with same spreadsheet?

#2 Post by Puppy » Sun Jan 15, 2012 3:07 pm

Create shortcut for the inventory.xls file in Start Menu. Default registered application for the file type (Excel) will open the file.
ThinkPad (1992 - 2012): R51, X31, X220
Huawei MateBook 13

BillP
Sophomore Member
Posts: 191
Joined: Mon Jul 23, 2007 4:04 pm
Location: Woodstock, NY

Re: How to force Excel to always open with same spreadsheet?

#3 Post by BillP » Sun Jan 15, 2012 3:24 pm

Here are a few references I found in a quick search.


Save the file into the XLStart folder, which is created when Excel is installed. In Windows XP, this folder is located at C:\Documents and Settings\[user]\Application Data\Microsoft\Excel\XLSTART. Anytime you open Excel, it automatically opens all files in that folder.

I just have a shortcut to my file and open that, as opposed to opening Excel, and clicking File>Open> and finding my file.

http://support.microsoft.com/kb/291288
ThinkPad T60 1951-43U (with many upgrades)

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 23841
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

Re: How to force Excel to always open with same spreadsheet?

#4 Post by RealBlackStuff » Sun Jan 15, 2012 4:12 pm

Thanks guys! :D
I'd figured out Puppy's and Billp's 2nd solution already, but don't want an extra entry in my Start menu.
The XLSTART solution will be it.
I checked Google like mad, but never saw any reference to this, good sleuthing!
Lovely day for a Guinness! (The Real Black Stuff)

Puppy
Senior ThinkPadder
Senior ThinkPadder
Posts: 2821
Joined: Sat Oct 30, 2004 4:52 am
Location: Prague, Czech Republic

Re: How to force Excel to always open with same spreadsheet?

#5 Post by Puppy » Sun Jan 15, 2012 4:20 pm

RealBlackStuff wrote: I'd figured out Puppy's and Billp's 2nd solution already, but don't want an extra entry in my Start menu.
Then it is easy. Replace existing shortcut to Excel application with shortcut to the particular XLS file in your Start Menu.
ThinkPad (1992 - 2012): R51, X31, X220
Huawei MateBook 13

Post Reply
  • Similar Topics
    Replies
    Views
    Last post

Return to “Off-Topic Stuff”

Who is online

Users browsing this forum: No registered users and 45 guests