I have the strangest problem (and it may be me, but hey, I've never seen it) that I could use some help on.
I have created an Excel form for calculating Expenses to be reimbursed that is complaining about external queries when I try to save it as a template and re-open it.
A little evolutionary history first, though:
Document was originally created in Excel 2002, then modified in 2000 SR-1 and eventually saved as a template using the same 2000 SR-1.
It has VBA for the workbook. Very little actually, so here is the code:
VBAProject (Reimbursement Request.xlt)
+Microsoft Excel Objects
Private Sub Worksheet_Change(ByVal Target As Range)
If ((Target.Column <> 4) And (Target.Column <> 5) And (Target.Column <> 7) And (Target.Column <> 8) And (Target.Column <> 9)) Then Exit Sub
If ((Target.Row < 8) Or (Target.Row > 35)) Then Exit Sub
--------End of Code--------
When I save this as a template I receive the following warning:
This workbook contains external data. Do you want Microsoft Excel to clear the data before saving the template and then automatically refresh the data whenever the template is opened? (Y/N/C)
Regardless of the answer I give (except Cancel of course), The resulting template file will give me the following upon opening:
Standard Enable Macros Warning
This workbook contains queries to external data that refresh automatically.
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or write information back to a database.
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, you can later refresh queries manually, if you are satisfied that the queries are safe.
[ ] Enable automatic query refresh for all workbooks and do not show the warning again
[Enable automatic refresh] [Disable automatic refresh]
-------------End of Warnings------------
There are NO external links, nor queries, nor code of any kind that I can see that points to any file or database ANYWHERE. Is there a technical reason I should be receiving the message even though everything is self contained?
Any assistance in solving this annoying conundrum would be greatly appreciated. Thank you.