Excel 2007 Corruption issue when saving a template

[maxime_lessard]

Attempting to save a *.xltm using eTools, save dynamic template.

Appears to save the file to the company folder.

When attempting to re-open the template from eTools, open dynamic templates, nothing happens (no message and the file does not open.)

Excel 2007

BPC MS 7.5

Release 7.5.112.07

To find the file, I have to open it from the server.  Sometimes, I get a message that the file is corrupt.  Sometimes, I get a message that the file can't be opened, sometimes it opens just fine.

When saving locally, without the BPC eTools, it saves and open no problems.  In all possible format (xls, xlt, xlts, xltm)

Tried solution in this thread, worked the first couple of time but does not seem to be a universal solution.

Attempted to save locally, change the format, change the extension, all to no avail.

This never happened in the last 3 years, I started noticing it a couple of months ago.  And now, it happens about once a week and I can't seem to figure out a pattern, seems random.

Help!

[maxime_lessard · Accepted solution]

I don't think syncing the patch level from Excel on the BPC server and on my computer fixed the corrupted file issue with BPC.

So, here is how I fix a supposedly corrupted Excel file from BPC where I got a message "Excel cannot open the file *.xltm because the file format or file extension is not valid"

Perquisite:

a) I'm running Excel 2007 on my local computer

b) BPC MS installed is 7.5.112.07

c) I have access to a remote machine with Excel 2013 installed

1. Open the file with Excel 2013 on remote machine with the eTools: open dynamic template. if it works, go to 4.

2. If 1 does not work, navigate to the BPC server using Windows Explorer and change the extension of the corrupted file to "xlt", click OK on the warning.

3. Open the renamed file from Excel 2013 on remote computer with the eTools: open dynamic template.

4. Click Refresh and see if the Macros are still present.  If not, add them again.

5. Then save again using eTools Dynamic template into a xltm format (or xltx if there are no macros).

6. Open the file with Excel 2007 on local machine, should work now.

But as soon as I tried re-saving a corrupted report with Excel 2007, it gets corrupted again.

I'm not sure if it works in all cases but the ones I was really stuck did convert properly using this method.

[maxime_lessard]

Just noticed that I'm Excel 2007 SP2 on my local machine and the server is on SP3.  Will attempt to update to SP3.

[Former Member]

Hi Maxime,

it happens with all reports or only will one specific? If all try upgrading the system will all the last sp otherwise rebuild the report from scratch, probably it's corrupted.

Regards

     Roberto

[maxime_lessard]

Specific ones. I'll be upgrading my Excel to match the server's version and will report back when this is done.