ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I'm getting files saved with names like 48A52100 with no .xls f. (https://www.excelbanter.com/excel-discussion-misc-queries/2302-im-getting-files-saved-names-like-48a52100-no-xls-f.html)

KELTON

I'm getting files saved with names like 48A52100 with no .xls f.
 
I'm getting spreadsheets saved on our network with an 8-character string as
the filename and no .xls file extension. Using the "Open with . . ." option
they successfully open with Excel. Does anyone know why this is happening?
--
Iain N Black

Jon Peltier

Kelton -

These are temp files created when Excel saves a workbook. Normally they are deleted
when the save is complete. This might fall under the funny behaviors that occur when
working with files on a network.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

KELTON wrote:

I'm getting spreadsheets saved on our network with an 8-character string as
the filename and no .xls file extension. Using the "Open with . . ." option
they successfully open with Excel. Does anyone know why this is happening?



Dave Peterson

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension).

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.

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.

KELTON wrote:

I'm getting spreadsheets saved on our network with an 8-character string as
the filename and no .xls file extension. Using the "Open with . . ." option
they successfully open with Excel. Does anyone know why this is happening?
--
Iain N Black


--

Dave Peterson


All times are GMT +1. The time now is 03:51 AM.

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