"Archimedes' Lever" wrote in message
...
On Mon, 15 Jun 2009 22:38:33 -0400, "Jon Peltier"
wrote:


"Archimedes' Lever" wrote in message
. ..
On Thu, 11 Jun 2009 15:25:43 -0400, "Jon Peltier"
wrote:

No, the problem wasn't the lack of 2007. I tried from my VM, which has
2007,
and the web site couldn't find 2007. When I went ahead anyway, the
template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.


It is there, andI definitely get a different list at work than I do
here.Are you sure a virtualized installation gets "seen" correctly at
the
MS site?

Neither my VMs nor my regular machine worked. I don't know why they can't
just post a link, like the rest of the world does.

- Jon

They segregate o2k7 and keep you from DLing "non-compliant" templates
for o2k3.

So they should let me click on a link for "Download Excel 2007 Workbook",
and if it doesn't work in 2003 it's my problem. Why do they feel the need to
babysit all of their users?

I can post it to a hosting site.

http://www.mediafire.com/?zmzqznvomxa

Thanks.

The problem is that you're using a multiple-level category axis. #N/A is
treated as a bit of text, and the axis extends to include the #N/A in the
date column.

If you're only protecting the charts to prevent the user accidentally
breaking something, don't bother with a password. I was not able to change
the category axis data range to verify that a single level category axis
scale, using #N/A for the 29th, would not show Feb 29 on non leap years.

Well, actually I could break the password. Most passwords in Office are not
very secure. And yes, if the X values includes only one column, not two,
then the axis behaves as I told you it would.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______