R
Ryan
I have a program in Access that exports data from queries into excel.
Everything in works great in excel 2003, but I keep gettting this error
message in excell 2007.
The name, 05PhysicianTotals, either conflicts with a
valid range reference or is invalid for Excel. The name has been
replaced with _1_05PhysicianTotals.
You may still need to manually update any references to this name used
in VBA code or as text arguments in functions. You must close and
reopen the workbook before these changes take effect.
It continues to do this for 5 more of my queries and each one moves up one
number like this
_2_
_3_
Can anyone help me with this issue? Does excel not like names that start
with numbers? One more thing to know is that it looks like each of the names
it is complaining about are comming from Union Queries in MS Access.
Everything in works great in excel 2003, but I keep gettting this error
message in excell 2007.
The name, 05PhysicianTotals, either conflicts with a
valid range reference or is invalid for Excel. The name has been
replaced with _1_05PhysicianTotals.
You may still need to manually update any references to this name used
in VBA code or as text arguments in functions. You must close and
reopen the workbook before these changes take effect.
It continues to do this for 5 more of my queries and each one moves up one
number like this
_2_
_3_
Can anyone help me with this issue? Does excel not like names that start
with numbers? One more thing to know is that it looks like each of the names
it is complaining about are comming from Union Queries in MS Access.