Dave
Sun Jun 15 19:49:38 CDT 2008
It sounds to me like you have an addin/workbook that's opening when excel opens.
You can look under the office button|Excel options under the Addins category --
or look in the Advanced category for the General section to look to see if
there's an entry in the "At startup, open all files in:". (But now I'm
repeating myself.)
You may want to read these pages:
Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm
And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp
sharon wrote:
>
> Hi,
>
> I can't delete the file, because it's autogenerated, but if I delete the map
> drive (having excel closed), when I try to open excel (even with /e option)
> it tries to open meteoclimatic.txt, exactly "M:\uploads\meteoclimatic.txt",
> but obviously it can't.
>
> I close excel and when open it again, it tries again to open
> meteoclimatic.txt. So still this info is saved anywhere in excel config
> file...
>
> So, where EXCEL 2007 has this info?
>
> Regarding to your question about where in Options appears this file I don't
> think it is the point, because the problem is why it looks to open this file.
> When it's opened it offers options to the file you have opened, so for
> instance you can say "I don't want autorecovering" for this particular file.
> In ADVANCED tab there are lots of options to configure (actual) file or
> general.
>
> So, IMO the point is get where this inside-link is saved or configured.
>
> Furthermore, it happened without my volition.
>
> Any clue?
>
> "Dave Peterson" wrote:
>
> > What happens when you try to delete the file?
> >
> > Did you close excel?
> >
> > Do you have read/write/delete access to the M: drive?
> >
> > Where (be specific) do you see that file under Tools|Options?
> >
> > sharon wrote:
> > >
> > > The formulas returns an error (#Value).
> > >
> > > If the question is the source name, if I do (within VBA)
> > > ?thisworkbook.fullname then returns "M:/weather/metoclimatic.txt" which is
> > > the original file Ineed to keep. I can't delete it. I need to find and remove
> > > the link.
> > >
> > > If I do:
> > > ?thisworkbook.Connections.count returns 0
> > >
> > > I don't have code in this workbook neither (AFAIK) connection established...
> > >
> > > I'm lost...
> > >
> > > Sharon
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > What did the =cell("filename",a1) formula return?
> > > >
> > > > sharon wrote:
> > > > >
> > > > > Sorry for my omission, my trouble is within 2007.
> > > > >
> > > > > I don't know how but suddenly I realized this trouble.
> > > > >
> > > > > The file is "meteoclimatic.txt" which is related to weather station. Doesn't
> > > > > mine.
> > > > > But I'm not able to find any active connection with it. The only place where
> > > > > I can see it is in Options - Save page where you can tell Excel no to do
> > > > > autorecovery for this file. But it's impossible, for me, to remove it!
> > > > >
> > > > > So, apparently, I know which is the file, but if it aims to the original one
> > > > > I need it, so what I need to remove is the 'connection' or 'link' ...
> > > > >
> > > > > I'd never seen this before in Excel. 2007 is driving me nuts!
> > > > >
> > > > > Sharon
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > In xl2003, I'd look at:
> > > > > >
> > > > > > Tools|Options|General tab
> > > > > > Make sure that the: "At startup, open all files in:" is empty.
> > > > > >
> > > > > > If that box is empty, then the next thing I'd do is search for all the XLStart
> > > > > > folders (there can be several) and look for that .txt file and remove it.
> > > > > >
> > > > > > In fact, if you open excel so that your .txt file is open, try putting this in
> > > > > > any old cell:
> > > > > >
> > > > > > =cell("Filename",a1)
> > > > > > (don't change anything)
> > > > > >
> > > > > > It should return the information that you need to find that text file and remove
> > > > > > it. (Make sure you close excel first.)
> > > > > >
> > > > > > Just a curiousity question--what's the name of the text file?
> > > > > >
> > > > > > If these suggestions don't help, maybe the name will help someone else help you.
> > > > > >
> > > > > > sharon wrote:
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > I don't know why but every time I load Excel it loads a txt.file in it. I
> > > > > > > applied what Dave said and then it opens 2 sheets, one blank and other with
> > > > > > > the .txt file.
> > > > > > >
> > > > > > > In Options - Save I can see in many places the name of this .txt file, such
> > > > > > > as in "Autorecovery Exceptions for :" but it can't be removed.
> > > > > > >
> > > > > > > If I add a new template in ../XLSTART folder then it woulkd load 2 sheeds
> > > > > > > again.
> > > > > > >
> > > > > > > I can't find where to disable this UNDESIRED load.
> > > > > > >
> > > > > > > Could it be related to publish for web format, or similar?
> > > > > > >
> > > > > > > Any clues?
> > > > > > >
> > > > > > > Sharon
> > > > > > >
> > > > > > > "Dave Peterson" wrote:
> > > > > > >
> > > > > > > > I don't think this has ever been caused by corruption.
> > > > > > > >
> > > > > > > > Alan wrote:
> > > > > > > > >
> > > > > > > > > On Mar 15, 1:26 am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > > > > > > > > > Sometimes one of these works when you're having trouble with double clicking on
> > > > > > > > > > the file in windows explorer:
> > > > > > > > > >
> > > > > > > > > > Tools|Options|General|Ignore other applications (uncheck it)
> > > > > > > > > >
> > > > > > > > > > --- or ---
> > > > > > > > > >
> > > > > > > > > > Close Excel and
> > > > > > > > > > Windows Start Button|Run
> > > > > > > > > > excel /unregserver
> > > > > > > > > > then
> > > > > > > > > > Windows Start Button|Run
> > > > > > > > > > excel /regserver
> > > > > > > > > >
> > > > > > > > > > The /unregserver & /regserver stuff resets some of the windows registry to
> > > > > > > > > > excel's factory defaults.
> > > > > > > > > >
> > > > > > > > > > sfleck wrote:
> > > > > > > > > >
> > > > > > > > > > > O3K
> > > > > > > > > >
> > > > > > > > > > > I attempt to open a file from outlook attachment, file on the desktop, and
> > > > > > > > > > > it does not do anything
> > > > > > > > > >
> > > > > > > > > > > Right click and open with and it is pointed to open with excel
> > > > > > > > > >
> > > > > > > > > > > open excel and go file - open and it open fine
> > > > > > > > > >
> > > > > > > > > > > Thank you in advance
> > > > > > > > > >
> > > > > > > > > > --
> > > > > > > > > >
> > > > > > > > > > Dave Peterson
> > > > > > > > >
> > > > > > > > > Sometimes this may caused by file corruption, and you can try some
> > > > > > > > > Excel file recovery tools, such as Advanced Excel Repair to repair
> > > > > > > > > your Excel file.
> > > > > > > > >
> > > > > > > > > Detailed information about Advanced Excel Repair can be found at
> > > > > > > > >
http://www.datanumen.com/aer/
> > > > > > > > >
> > > > > > > > > And you can also download a free demo version at
http://www.datanumen.com/aer/aer.exe
> > > > > > > > >
> > > > > > > > > Hope this will help.
> > > > > > > > >
> > > > > > > > > Alan
> > > > > > > >
> > > > > > > > --
> > > > > > > >
> > > > > > > > Dave Peterson
> > > > > > > >
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >
--
Dave Peterson