#1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default File not opening

Try this first (from Debra Dalgleish's site):
http://www.contextures.com/xlfaqApp.html#ReadOnly


If that doesn't work...

It sounds like your file got corrupted.

For future use...

If you're using xl2002+, turn on autorecovery. Tools|options|save tab

If you're using xl2k or below, get a copy of Jan Karel Pieterse's addin called
AutoSafe. (It actually works with any version.)

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.

For your current dilemma:

Lots of people have praised OpenOffice.org for saving their data and code.
http://www.openoffice.org, a 60-104 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)

Nawaz50 wrote:

I was working with a file, due to electricity breakdown computer
shutdown. when I restarted and opened that file it gave message:
"file name" cannot be accessed. The file may be read only, or you may
be trying to access read only location. Or the server the document is
stored on may not be responding.

file is saved on my computer.

how can I open this file.

--
Nawaz50
------------------------------------------------------------------------
Nawaz50's Profile: http://www.excelforum.com/member.php...o&userid=33938
View this thread: http://www.excelforum.com/showthread...hreadid=540153


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem opening Excel file giantwolf Excel Discussion (Misc queries) 6 March 30th 06 08:58 AM
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 09:05 PM
Formula related Crash on Opening File Nodak Excel Worksheet Functions 0 June 15th 05 01:41 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Opening a file with a Macro Adam1 Chicago Excel Discussion (Misc queries) 2 February 28th 05 10:13 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"