Excel 2000 & NAV 2003

[Gerry Cornell]

This morning when I tried to open an Excel file in Windows Explorer ( Windows XP / Internet Explorer ) the file did not open. It stalled on "Virus scan requested". I am using Norton Anti Virus 2003. I still cannot get the files to open that way. The file does open if you load Excel and then select File, Open and browse to the required file.

In the normal way the virus scan can take a moment but I have never encountered this problem before. Earlier I remember that NAV updated definitions to 7 June 2004, which makes me wonder whether the latest update contains a bug.

I am interested in knowing whether any one has encountered a similar problem today?



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Jim Rech]

Make sure "Ignore other applications" is not selected under Tools, Options,
General.

--
Jim Rech
Excel MVP
This morning when I tried to open an Excel file in Windows Explorer (
Windows XP / Internet Explorer ) the file did not open. It stalled on "Virus
scan requested". I am using Norton Anti Virus 2003. I still cannot get the
files to open that way. The file does open if you load Excel and then select
File, Open and browse to the required file.

In the normal way the virus scan can take a moment but I have never
encountered this problem before. Earlier I remember that NAV updated
definitions to 7 June 2004, which makes me wonder whether the latest update
contains a bug.

I am interested in knowing whether any one has encountered a similar problem
today?



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Gerry Cornell]

Jim

Spot on. It was selected. Now it works as before. However, I do not recollect checking that option! There was no problem yesterday.

Recently I have been saving xls files as csv files. Not knowing anything about the option is there any connection? A curiousity I have encountered is that when I am saving as a csv file I seem to be getting an extra invitation to save the file, when I immediately close the CSV file. After I said yes to the extra invitation to save I found it was changing a date format to an unwanted date format ( one I would normally use ) so I have been selecting No. I then close Excel and open the CSV file with Notepad to check that the data is correct for importing into an accounting package.

Could there be any connection with the procedures described and this latest problem opening XLS files?

Thank for your help.



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Jim Rech]

This extra "save?" message you get after saving in CSV format is quite
annoying but, as far as I know, it doesn't have anything to do with the
"Ignore" option.

The Ignore option is a user-level setting that gets saved in the registry
when Excel exits and restored when Excel opens. Something set it on
obviously. I've seen Excel applications that do this when they are active
(my own for example) but these apps should always set it back when they
exit. Some don't, either because the developer overlooked it or because
there was a macro error that prevented the normal close code from resetting
it.

--
Jim Rech
Excel MVP
Jim

Spot on. It was selected. Now it works as before. However, I do not
recollect checking that option! There was no problem yesterday.

Recently I have been saving xls files as csv files. Not knowing anything
about the option is there any connection? A curiousity I have encountered is
that when I am saving as a csv file I seem to be getting an extra invitation
to save the file, when I immediately close the CSV file. After I said yes to
the extra invitation to save I found it was changing a date format to an
unwanted date format ( one I would normally use ) so I have been selecting
No. I then close Excel and open the CSV file with Notepad to check that the
data is correct for importing into an accounting package.

Could there be any connection with the procedures described and this latest
problem opening XLS files?

Thank for your help.



~~~~~~

TIA.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Gerry Cornell]

Jim

Are you saying the "extra save" is an inbuilt "bug"?

I have rechecked through Event Viewer but I cannot see anything suggesting what might have happened. I did look through settings yesterday but I am fairly sure didn't check it. I guess I will never know the cause unless it happens again.

--

~~~~~~

Regards.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~

 

[Jim Rech]

I'm not saying it's a bug but it does seem to be a "feature".

--
Jim Rech
Excel MVP
Jim

Are you saying the "extra save" is an inbuilt "bug"?

I have rechecked through Event Viewer but I cannot see anything suggesting
what might have happened. I did look through settings yesterday but I am
fairly sure didn't check it. I guess I will never know the cause unless it
happens again.

--

~~~~~~

Regards.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~