Sheet -> Insert Dialog Default File Location

[Guest]

Hello,

When I right-click on a sheet and click Insert, the Insert dialog displays.
On my PC, the Insert dialog shows 6 tabs corresponding to folders on my PC
and shows all my Excel documents. It allows me to insert entire workbooks
into the current workbook. It nicely resolves any references to the inserted
workbook that were in the current workbook. These documents are not saved as
templates, just normal .xls.

What I can't figure out is how do I get this dialog to show other locations
on my PC as well? I can't seem to find where it is picking up these locations
to display in the Insert dialog in the first place. Other PCs at my location
only show the default "General" and "Spreadsheet Solutions" tabs with the
default items (worksheet, chart, Expense Statement, etc.).

The Tools, Options, General tab shows a completely different location for
the Default File Location than what is being displayed in the Insert dialog.

Please help?!

Darla

 

[Dave Peterson]

I think if I were going to use this, I'd be selective about what I put in this
templates folder (not all my workbooks for sure!).

Anyway, you'll want to find your templates path.

A quick way to make sure you have the correct one:
open excel
hit alt-f11 to see the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.TemplatesPath

In win98 and xl2002, I get this back:
C:\WINDOWS\Application Data\Microsoft\Templates\

Any folder that I put under this templates folder will show up as a tab (if it
has something that excel likes in it).

So create a new folder Named "Darla's Templates"
And instead of copying the workbooks you want, you may want to create shortcuts
to those workbooks.

In windows explorer,
In your workbooks folder
select the files (Click and ctrlclick and ctrlclick...)
then go to "Darla's Templates" folder
Rightclick and choose to paste shortcuts.

Then you'll only have one version of those files and when the real one changes,
you won't have to worry about updating the template version.

===
If you need this for a workgroup (shared templates), you can do something
similar with the workgroup templates folder.

You can find that location in MSWord under Tools|Options|file locations
or if you have the msoffice shortcut bar loaded, rightclick on it
Customize|Settings tab

I'd still use shortcuts to files stored on a network folder, though. (I like
one "real" copy of the workbook/template. (But multiple backups!).)