ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   .xlt does not contain new data from source spreadsheet. (https://www.excelbanter.com/excel-discussion-misc-queries/227041-xlt-does-not-contain-new-data-source-spreadsheet.html)

JRussell

.xlt does not contain new data from source spreadsheet.
 
I updated the source files to add and remove some rows. The .xlt file that
is used to display the data show the old data. I do I refresh the .xlt file?
--
JRussell

Gord Dibben

.xlt does not contain new data from source spreadsheet.
 
An *.xlt file is a Template.

When you open that workbook, the *xlt itself does not
open................just a copy of the *.xlt opens which you save as an
*.xls file.

That is what you saved.............the copy.

To actually open an *.xlt file for editing you must go to your folder and
right-click on the file and "open" the *.xlt file

Do your editing then save that *.xlt file.


Gord Dibben MS Excel MVP

On Wed, 8 Apr 2009 07:14:06 -0700, JRussell
wrote:

I updated the source files to add and remove some rows. The .xlt file that
is used to display the data show the old data. I do I refresh the .xlt file?




All times are GMT +1. The time now is 05:20 PM.

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