Unable to default view/zoom and window size/location in Workbook template

[Geoff Clark]

[version - Excel 2004, OS X 10.3.9]

I’ve searched this newsgroup’s archives and learned that saving a new Workbook in the default startup location should very easily solve the issue of default zoom and window size and location on the screen (as I’m using the large cinema display and 100% requires a magnifying glass; and a 6-page default workbook size is excessive and blocks everything else on the screen upon startup), however no success with this solution.

Any other suggestions (not too keen on building a VB add-in, but would if I absolutely have to)?

Many thanks in advance for anyone’s help :)

[JE McGimpsey]

In article <BE950604.9B51%geoffr...@yahoo.com>,
Geoff Clark <geoffr...@yahoo.com> wrote:

> I靶e searched this newsgroup零 archives and learned that saving a new

> Workbook in the default startup location should very easily solve the issue

> of default zoom and window size and location on the screen (as I雋 using the

> large cinema display and 100% requires a magnifying glass; and a 6-page
> default workbook size is excessive and blocks everything else on the screen
> upon startup), however no success with this solution.
>
> Any other suggestions (not too keen on building a VB add-in, but would if I
> absolutely have to)?
>

> Many thanks in advance for anyone零 help :)

What do you mean by "no success"?

Assuming you have no add-ins that would change settings:

Create your workbook with the properties you want, including zoom, size
and location.

Save it *as a template* (choose "Template" in the Format dropdown in the
Save As dialog) in the

Application:Microsoft Office 2004:Office:Startup:Excel:

folder (or your alternative startup folder, if you've set one in
Preferences/General), with the name

Workbook

Note that there's no extension.

From then on, new workbooks will open with the same properties.

[Geoff Clark]

That's precisely what I have done, and so I don't understand why the
settings aren't sticking (used template format, no exensions, saved in the
default folder, tried creating and saving into a new alternative folder).
Tried "Workbook", "workbook", regular file, template file, default location
and defined alternative folder as mentioned. Hmmmmmm.......

On 4/27/05 2:15 PM, in article
jemcgimpsey-8109...@msnews.microsoft.com, "JE McGimpsey"

[Geoff Clark]

Quick update - I ended up reinstalling office as I had a couple of excel
crashes (freezing upon Quit). After setting a custom location and creating
the template file, it is now working.

Thanks for the assistance!

On 4/27/05 2:15 PM, in article
jemcgimpsey-8109...@msnews.microsoft.com, "JE McGimpsey"
<jemcg...@mvps.org> wrote: