Thread: How to copy formula without warning popup

Hi,


I am trying to create a excel (using excel 2007) file that uses formula referenced to cell names.


I attached a part as example. As you can see, cell names in column B are created using column A (using name manager > Create from selection). So the formulas in column E use this cell names, and generates data.

Now, as I have to do it in multiple spreadsheets (same column names and formula, just data in column B changes), I tried to copy the formulas to other files (xls), but it gives me a warning like this (attached image):

http://img705.imageshack.us/img705/2628/73927041.jpg



is there any way I can disable this warning message ? (as I have to click/say yes almost 300 times)


or any way to copy the formulas that will not generate this warning? I am open to use a macro if needed.


Thanks in advance.