Error:Invalid File format,while opening an Excel Template file

Hi,
I'm having a .xls file which through code is creating daily report
files.These daily report files are being saved as .xlt files(excel templates).
All these days I was able to open and view the saved .xlt report files but
very recently while opening saved .xlt files I'm getting an error which says
"File Name:Invalid File format"

Can someone help me with the resons behind such error also I'd be thankfull
if someone can suggest me the solution for the same.

Expecting an early response

Saurabh

The files should be saved as XLS not XLT.

"Saurabh" wrote:

> Hi,
> I'm having a .xls file which through code is creating daily report
> files.These daily report files are being saved as .xlt files(excel templates).
> All these days I was able to open and view the saved .xlt report files but
> very recently while opening saved .xlt files I'm getting an error which says
> "File Name:Invalid File format"
>
> Can someone help me with the resons behind such error also I'd be thankfull
> if someone can suggest me the solution for the same.
>
> Expecting an early response
>
> Saurabh
>

I believe as the error statement correctly suggests the error is being caused due to invalid extension. Don?t worry there are several workarounds to this, I am sharing them below:

Method 1 ? Change the Default File Format to Save Excel Workbooks

In Excel 2007, click the ?Microsoft Office? button and then ?Excel Options?. In Excel 2010 and higher versions, click File > Options.

Select Export option.

Select Change File Type option.

Change the file extension, and then click Save As.


Method 2 ? Recover Unsaved Workbook

Go to File and select Info option.

Under Manage Versions, select ?Recover Unsaved Workbooks? op

If MS Excel has unsaved files then, it will list them. You can open and save it.


Method 3 ? Use 'Open and Repair' Feature of MS Excel

Open MS Excel application.

Go to File and Select Open option.

Select the corrupt file and choose Open and Repair option.

You can also check this forum:

https://social.technet.microsoft.com...ffice2016ITPro

Thanks!

Why are you replying to a 17 year old thread?