Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
I have office 2007. Today I opened a templete made some changes and saved it
with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
Eric
I would try taking all the periods out of the file name, I would be surprised if XL would have an idea of the extension with them -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... I have office 2007. Today I opened a templete made some changes and saved it with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
Sorry I forgot to mention that. I renamed it to 'Test' with no change.
"Nick Hodge" wrote: Eric I would try taking all the periods out of the file name, I would be surprised if XL would have an idea of the extension with them -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... I have office 2007. Today I opened a templete made some changes and saved it with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
Eric
The beauty of the new file format is that you can take a copy, rename the extension to *.zip and see the text content of the file. It's not necessarily for the novice, but with care you should be able to correct the issue internally or delete just the 'component' causing the issue There is some basic detail here http://www.nickhodge.co.uk/2007files/fileformat.htm But if you want to email me the file I'll take a look -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... Sorry I forgot to mention that. I renamed it to 'Test' with no change. "Nick Hodge" wrote: Eric I would try taking all the periods out of the file name, I would be surprised if XL would have an idea of the extension with them -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... I have office 2007. Today I opened a templete made some changes and saved it with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
When I rename the file to .zip it still opens with excel. is there a trick to
doing this? If you open it with notepad every thing is jumbled. "Nick Hodge" wrote: Eric The beauty of the new file format is that you can take a copy, rename the extension to *.zip and see the text content of the file. It's not necessarily for the novice, but with care you should be able to correct the issue internally or delete just the 'component' causing the issue There is some basic detail here http://www.nickhodge.co.uk/2007files/fileformat.htm But if you want to email me the file I'll take a look -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... Sorry I forgot to mention that. I renamed it to 'Test' with no change. "Nick Hodge" wrote: Eric I would try taking all the periods out of the file name, I would be surprised if XL would have an idea of the extension with them -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... I have office 2007. Today I opened a templete made some changes and saved it with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt .xltm
Eric
I've got your file. To rename correctly in windows you have to show the extensions in windows. It's a folder properties option in Windows. What you are seeing is estimator, actually what is there is estimator.xltm by not showing extensions, renaming estimator (as you see it) results in estimator.zip.xltm so it is still a xl file. That is why I ask you for the original xlt file as I think this may be your issue -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... When I rename the file to .zip it still opens with excel. is there a trick to doing this? If you open it with notepad every thing is jumbled. "Nick Hodge" wrote: Eric The beauty of the new file format is that you can take a copy, rename the extension to *.zip and see the text content of the file. It's not necessarily for the novice, but with care you should be able to correct the issue internally or delete just the 'component' causing the issue There is some basic detail here http://www.nickhodge.co.uk/2007files/fileformat.htm But if you want to email me the file I'll take a look -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... Sorry I forgot to mention that. I renamed it to 'Test' with no change. "Nick Hodge" wrote: Eric I would try taking all the periods out of the file name, I would be surprised if XL would have an idea of the extension with them -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Eric" wrote in message ... I have office 2007. Today I opened a templete made some changes and saved it with an updated name. Now every time I try to open the file I get the message "Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format of file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I can still opent the older file 'Estimator 5.10.07.xltm' What gives? I only chaged some values, very basic changes. The only thing I can think of is that my computer ran Automatic update and did update 1 thing. Also, this is the second time I have made these changes and resaved with the same results. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt Pivot Table | Excel Discussion (Misc queries) | |||
The document is corrupt | Excel Discussion (Misc queries) | |||
Corrupt Excel File | Excel Discussion (Misc queries) | |||
Corrupt Excell file | Excel Discussion (Misc queries) | |||
Corrupt Spreadsheet | Excel Discussion (Misc queries) |