Cannot Expand Name Range

K

Ken

I'm trying to export query results into Excel 2000 file and get the above
message. Only option is OK and HELP. When I click on HELP, I get blank window.

Does anyone know what is causing this? I been exporting to Excel since I was
a baby and now all of a sudden it wants to play some hocus/pocus game.

Thanks in advance and have the great Labor Day Weekend.
 
J

John Nurick

Hi Ken,

Is there anything in the workheet below the named range you're exporting to?
 
L

Lynn Trapp

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819

A caution about specifying ranges: When you specify a worksheet as your
recordsource, the provider adds new records below existing records in the
worksheet as space allows. When you specify a range (named or unnamed), Jet
also adds new records below the existing records in the range as space
allows. However, if you requery on the original range, the resulting
recordset does not include the newly added records outside the range.

With MDAC versions prior to 2.5, when you specify a named range, you cannot
add new records beyond the defined limits of the range, or you receive the
following error message:

Cannot expand named range.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Top