template external data

I'm saving my updates in my workbook automatically to a new template: Application.ActiveWorkbook.SaveAs fileToSave, xlOpenXMLTemplateMacroEnabled However, Excel always asks me if I want to clear external data and refresh it after template is opened: I don't want Excel to clear external data...

Hi all. I have been tasked with creating an excel template that will allow another division in our company to enter information about specific new products. This form will then be handed off to another division to process the products for retailing. Each product can live in one of ~650...

I have some questions about this macro, that I used to make a chart. I'm a newbie creating macros. Thanks so much and sorry for so many questions. How do I make this macro work on a different user's computer? ActiveChart.ApplyChartTemplate ( _...

I am in charge of metrics for my company and we gather a lot of different information from different sources. Currently I have created a workbook that has 5 different data worksheets and 7 worksheets that calculates and displays the information. I am trying to create a Client Template where I...

I have a TEMPLATE workbook that has 106 cells (all in the same worksheet) that need to have data input in them. I have a separate DATA workbook with 3,000 rows of data, each row has 106 columns that correspond to the cells in the TEMPLATE workbook. I need to create 3,000 new workbooks that are...

Hello All, I have been struggling with this issue for sometimes now. Any help would be greatly appreciated. I currently have a macro that opens up a number of sheets and names the sheets according to a list I have. The sheets that the macro opens are based on a Template that I have created...

Hi all, I just created an Excel spready with numerous formula in it. I cleared the raw data and left the formulae, before saving as a template. When I do save it as a Template the following pops up: "This workbook contains external data. Do you want Microsoft Excel to clear the data before...