Re: Excel 2000 & NAV 2003
From: Jim Rech (jrrech_at_hotmail.com)
Date: 06/08/04
- Next message: Haggisdog: "Indirect and Address Functions to Determine Schedule"
- Previous message: esq: "Converting to PDF: Hyperlinks"
- In reply to: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Next in thread: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Reply: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 09:40:36 -0400
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 "Gerry Cornell" <gcjc@btinternet.com> wrote in message news:eF6qbDVTEHA.1544@TK2MSFTNGP09.phx.gbl... 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" <jrrech@hotmail.com> wrote in message news:eUQGlVUTEHA.332@TK2MSFTNGP11.phx.gbl... > Make sure "Ignore other applications" is not selected under Tools, > Options, > General. > > -- > Jim Rech > Excel MVP > "Gerry Cornell" <gcjc@btinternet.com> wrote in message > news:e3mPeuTTEHA.2128@TK2MSFTNGP11.phx.gbl... > 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. > ~~~~~~~~~~~~~~~~~~~~~~~~ > >
- Next message: Haggisdog: "Indirect and Address Functions to Determine Schedule"
- Previous message: esq: "Converting to PDF: Hyperlinks"
- In reply to: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Next in thread: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Reply: Gerry Cornell: "Re: Excel 2000 & NAV 2003"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
