data range referrences

[Jon Peltier]

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.

- Jon

 

[Archimedes' Lever]

I think the problem is that the MS site "helpfully" checks whether I have
2007 installed on my machine (I do, but on a VM, not on the main machine).

That is correct. When I am at work, my templates do not show up as we
are 2k3 at work.

 

[Archimedes' Lever]

No?

Darn.


http://office.microsoft.com/search/redir.aspx?assetid=TC300058731033&respos=22&pid=CT101436151033

The string has "assetid" in it. I wonder what that could be...?

Can you not get a friend to grab it for you and send it to you?

At least they finally got the thumbnail screenshots working.

Dang! You cannot see that either!

 

[Archimedes' Lever]

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?

 

[Jon Peltier]

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

 

[Archimedes' Lever]

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.


I can post it to a hosting site.

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

 

[Jon Peltier]

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

 

[Archimedes' Lever]

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?

Ya got me. They also DUMP all the template submissions into a single
page, and all the retarded powerpoint greeting card templates flood out
all the real excel templates. I suggested that there is enough traffic
that they should be making a templates page for each office suite
application.

I cannot find any of my submission, which were being downloaded
anymore, because some lame powerpoint twit has been flooding the
submissions page, and that is followed on by some lame twit at MS that
thinks an all black page with white text is a viable candidate for being
called a valid template submission.

It really is sad. My task tracker had several thousand downloads, and
now it is obscured and only gets downloaded by folks that have been told
about it by others. The only way to get it back out in front is to
re-submit it, which then gets flooded by the retarded greeting card
dolts.

 

[Archimedes' Lever]

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?


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.

I found my solution is to merely hide the 29 row from the Feb data
sheet, and the Feb 29 row from the year data sheet. That updates
perfectly in the charts.

If you're only protecting the charts to prevent the user accidentally
breaking something, don't bother with a password.

I gave the password in the description on the MS site, but not the
hosted site. It is "Generic", IIRC.

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.

It is likely the reason it didn't. I am sure that you noted it right
away. So I tossed an unintentional curve in there.

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.

Ahh.. I gather both the date, and the Day moniker for that axis.

My hide routine looks like the right path at this point.
Thanks, Jon.