Home » Forums » Open Source Learning Center » Question and Answer

Filename will not display on an Excel Template

Submitted by Monica on 10 October, 2012 - 15:59

Hi,
We have a template with a cell - =cell(filename).
If we save the template as XLT, the filename is blank.
save as XLTM - the filename is displayed correctly.

then the XLTM displays the filename on some PC's, but not all.

Anyone have any ideas ?
The templates do not have macros, so I would like to save them as .XLT

Thanks for any help
Monica

‹ Formula to Match 2 Conditions [Days360} How can Excel copy from a one sheet to others by auto sorting by dates? ›
»

Excel's CELL function in Template file

Submitted by manny on 10 October, 2012 - 21:54.

Hi,

There is no problem with the file type (.xlt, . xltm, ...).

Actually when double-click on a Template file, you do not open the file but its copy, which is a new file, and for that reason before you save it there is no real file path and name (it is created in some temporary directory) and the CELL function returns an empty string. After you save the new file, press F9 for recalculating or reopen the file and you will see the file name in the cell.

If you want to open the actual Template file right-click on the file and choose Open, because for the double-click command the default action is New. Then you will see the file path and name of the Template file.

I hope my explanation is clear enough, because English is not my best part :) .

 

Best regards.

»

templates

Submitted by Monica on 11 October, 2012 - 15:27.

thanks a million.

Great Explanation
and perfect english.

Thanks again
Monica

»