LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Transfer Spreadsheet problems

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.
--
Please remember to mark this post as answered if this solves your problem.
 
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
Works spreadsheet transfer to excel Gary Excel Discussion (Misc queries) 0 February 21st 08 10:28 PM
Transfer Spreadsheet question... NWO Excel Discussion (Misc queries) 0 June 13th 07 09:38 PM
automatically transfer data from one spreadsheet to another farley Excel Worksheet Functions 1 April 18th 07 02:34 AM
Transfer Spreadsheet Mary Excel Worksheet Functions 0 May 9th 06 08:23 PM
Transfer text to another spreadsheet Susan New Users to Excel 12 March 23rd 06 10:06 PM


All times are GMT +1. The time now is 07:06 PM.

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

About Us

"It's about Microsoft Excel"