data range referrences

  • Thread starter Thread starter FatBytestard
  • Start date Start date
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
 
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).
Click to expand...


That is correct. When I am at work, my templates do not show up as we
are 2k3 at work.
 
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.
Click to expand...

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?
 
Archimedes' Lever said:
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?
Click to expand...

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 said:
They segregate o2k7 and keep you from DLing "non-compliant" templates
for o2k3.
Click to expand...

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
Click to expand...

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
 
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?
Click to expand...


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.
 
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.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top