ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Cannot open Excel Documetn (https://www.excelbanter.com/setting-up-configuration-excel/132471-cannot-open-excel-documetn.html)

Chad Guiney

Cannot open Excel Documetn
 
I have an excel document that I am all of the sudden unable to open. The file
is 5,447 KB big. I get the error

'filename.xls' cannot be accessed This file may be corrupted, located on a
server that is not responding or read only.

Is there any idea what could be preventing the file from opening. I have
rebooted the server so I know it is not someone who has the file open and I
know the file is not read only. Thanks in advance!!

Chad Guiney

Cannot open Excel Documetn
 
I just notiecd that in the same directory are a ton of files that have no
extension or any hint of what kind of files they are they just say C822BA00
for example and have no extension not even .tmp. However when I double click
them I find the info from the original spread sheet with different info.
Almost like each time a user closes or opens the file a new extensionless
file is created with the data. Any idea what is happening here??? I am very
confused. Thanks


"Chad Guiney" wrote:

I have an excel document that I am all of the sudden unable to open. The file
is 5,447 KB big. I get the error

'filename.xls' cannot be accessed This file may be corrupted, located on a
server that is not responding or read only.

Is there any idea what could be preventing the file from opening. I have
rebooted the server so I know it is not someone who has the file open and I
know the file is not read only. Thanks in advance!!


Dave Peterson

Cannot open Excel Documetn
 
When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

If you're seeing that funny named file, then something is going wrong.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Chad Guiney wrote:

I just notiecd that in the same directory are a ton of files that have no
extension or any hint of what kind of files they are they just say C822BA00
for example and have no extension not even .tmp. However when I double click
them I find the info from the original spread sheet with different info.
Almost like each time a user closes or opens the file a new extensionless
file is created with the data. Any idea what is happening here??? I am very
confused. Thanks

"Chad Guiney" wrote:

I have an excel document that I am all of the sudden unable to open. The file
is 5,447 KB big. I get the error

'filename.xls' cannot be accessed This file may be corrupted, located on a
server that is not responding or read only.

Is there any idea what could be preventing the file from opening. I have
rebooted the server so I know it is not someone who has the file open and I
know the file is not read only. Thanks in advance!!


--

Dave Peterson


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com