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 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