EXCEL 2000 AND WINDOWS VISTA

  • Thread starter Thread starter Lindsay Graham
  • Start date Start date
L

Lindsay Graham

I'm finding that cell formatting (eg, dates) will no longer work in Excel
2000. Whether it is an existing spreadsheet or a new one, cell formatting
does not work, and all dates entered are treated as text. This applies
whether the cell formatting is done before or after the date is entered.

It does appear to be a Vista/Excel 2000 conflict of some sort as it did not
happen until after I got Vista. And I've just opened (from a Windows XP
computer on the same network) some of the offending files, and the problem
does not exist.

Has anyone else experienced this? Is there a workaround available?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.
 
Lindsay Graham wrote:

> I'm finding that cell formatting (eg, dates) will no longer work in Excel
> 2000. Whether it is an existing spreadsheet or a new one, cell formatting
> does not work, and all dates entered are treated as text. This applies
> whether the cell formatting is done before or after the date is entered.
>
> It does appear to be a Vista/Excel 2000 conflict of some sort as it did
> not
> happen until after I got Vista. And I've just opened (from a Windows XP
> computer on the same network) some of the offending files, and the problem
> does not exist.
>
> Has anyone else experienced this? Is there a workaround available?
>

Someone reading this group might know the answer (and I'm sorry but I
don't) however, the best place for you to ask this question is in the
Excel newsgroup. That's where the Excel experts hang out.

microsoft.public.excel

Malke
--
MS-MVP
Elephant Boy Computers
www.elephantboycomputers.com
Don't Panic!
 
Hello Lindsay,

I am running Office 2000 on Vista. There are some things like Outlook
that don't work. Also some functionality in other programs, but I don't
have any problem formatting cells. One thing that I have done is to go
to the program file (I believe a shortcut will also work), right click
and select the compatibility tab. Tick the 'Run this program in
compatibility mode for' and select windows 2000 from the drop down list.

Hope it works for you.


--
garysgold

Vista Home Premiumx32 SP1-Q6600 Quad Core 2.40 GHz
4 GB Ram 800 MHz-Nvidia 8600GTS 256MB
500 GB HD-Exp. Index=5.5
http://garysgold.com
 
Thanks, Malke. I started the thread on an Excel newsgroup, got lots of
help, but no solutions. When I realised that it is (or at least appears to
be) a Vista-caused problem, I thought I might get more joy here. Still
hoping.

Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

"Malke" <malke@invalid.invalid> wrote in message
news:e40kkM7yIHA.2340@TK2MSFTNGP04.phx.gbl...
> Lindsay Graham wrote:
>
>> I'm finding that cell formatting (eg, dates) will no longer work in Excel
>> 2000. Whether it is an existing spreadsheet or a new one, cell
>> formatting
>> does not work, and all dates entered are treated as text. This applies
>> whether the cell formatting is done before or after the date is entered.
>>
>> It does appear to be a Vista/Excel 2000 conflict of some sort as it did
>> not
>> happen until after I got Vista. And I've just opened (from a Windows XP
>> computer on the same network) some of the offending files, and the
>> problem
>> does not exist.
>>
>> Has anyone else experienced this? Is there a workaround available?
>>
>
> Someone reading this group might know the answer (and I'm sorry but I
> don't) however, the best place for you to ask this question is in the
> Excel newsgroup. That's where the Excel experts hang out.
>
> microsoft.public.excel
>
> Malke
> --
> MS-MVP
> Elephant Boy Computers
> www.elephantboycomputers.com
> Don't Panic!
 
Thanks for the suggestion, "garysgold". I selected both Windows XP and
Windows 200, but neither made any difference. I have not yet rebooted, but
will let you know if that helps at all.

I'm not using Outlook (and I have heard there are some compatibility
problems there). But what functionality do you have problems with in other
programs?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

"garysgold" <guest@unknown-email.com> wrote in message
news:40792d749d27d4085ac72d1b2a49c251@nntp-gateway.com...
>
> Hello Lindsay,
>
> I am running Office 2000 on Vista. There are some things like Outlook
> that don't work. Also some functionality in other programs, but I don't
> have any problem formatting cells. One thing that I have done is to go
> to the program file (I believe a shortcut will also work), right click
> and select the compatibility tab. Tick the 'Run this program in
> compatibility mode for' and select windows 2000 from the drop down list.
>
> Hope it works for you.
>
>
> --
> garysgold
>
> Vista Home Premiumx32 SP1-Q6600 Quad Core 2.40 GHz
> 4 GB Ram 800 MHz-Nvidia 8600GTS 256MB
> 500 GB HD-Exp. Index=5.5
> http://garysgold.com
 
Haven't found anything within a single program in office2K so far. Noticed
that some links between Exel and Access don't seem to work. I was only
playing as I don't use Access anymore. Great prog. just more than I need.

Good luck,
garysgold

"Lindsay Graham" <LDGraham@aapt.net.au> wrote in message
news:Olllf27yIHA.420@TK2MSFTNGP02.phx.gbl...
> Thanks for the suggestion, "garysgold". I selected both Windows XP and
> Windows 200, but neither made any difference. I have not yet rebooted,
> but will let you know if that helps at all.
>
> I'm not using Outlook (and I have heard there are some compatibility
> problems there). But what functionality do you have problems with in
> other programs?
>
> --
> Lindsay Graham
> Canberra, Australia
> ---------------------------------------------
> Please reply only to the list/newsgroup so that all may benefit.
>
> "garysgold" <guest@unknown-email.com> wrote in message
> news:40792d749d27d4085ac72d1b2a49c251@nntp-gateway.com...
>>
>> Hello Lindsay,
>>
>> I am running Office 2000 on Vista. There are some things like Outlook
>> that don't work. Also some functionality in other programs, but I don't
>> have any problem formatting cells. One thing that I have done is to go
>> to the program file (I believe a shortcut will also work), right click
>> and select the compatibility tab. Tick the 'Run this program in
>> compatibility mode for' and select windows 2000 from the drop down list.
>>
>> Hope it works for you.
>>
>>
>> --
>> garysgold
>>
>> Vista Home Premiumx32 SP1-Q6600 Quad Core 2.40 GHz
>> 4 GB Ram 800 MHz-Nvidia 8600GTS 256MB
>> 500 GB HD-Exp. Index=5.5
>> http://garysgold.com
>
 
Back
Top