Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Update existing excel file on template change

Is it possible to force changes in existing excel workbooks by changing the
template they were based on, or instructing users to use new supplied
template?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Update existing excel file on template change

Unlike Word, once a workbook is created from a template, there's no
remaining connection between the template file and the workbook. You'd
need to provide some code in the workbook that checked for an update to
the template. However, that wouldn't force anything, since opening the
workbook with macros disabled would bypass the update.


In article ,
Gibz wrote:

Is it possible to force changes in existing excel workbooks by changing the
template they were based on, or instructing users to use new supplied
template?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
i want to update one excel file the other one update automaticaly Basant New Users to Excel 1 December 16th 06 12:50 AM
Insert several Excel files into existing Excel file? Jugglertwo Excel Discussion (Misc queries) 1 December 11th 06 06:18 PM
Pivot Table external XLS file source change and GETPIVOTDATA refresh mbobro Excel Discussion (Misc queries) 0 July 8th 06 12:45 PM
Open an existing excel speadsheet, opens Excel but not the file?? Smeeta Geary Excel Discussion (Misc queries) 1 September 19th 05 03:28 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"