Cannot Expand Named Range

2

22strider

Active Member
Joined
Jun 11, 2007
Messages
311
Hello Friends

Has anybody figured out why some times we get following error message when exporting data to Excel?
"Cannot Expand Named Range"
Use Access 2007 and I run a weekly export and have saved export that I use. Earlier I used to export query result in Excel 2003 and never had this problem. But with time number of records have grown and exporting to Excel 2003 is not an option anymore. So I tried exporting to Excel 2007. That's when I started getting this problem. And it only happens when export is over writing a file that already exists in the destination folder. That is critical if you are looking to automate the function.
Does anyone know fix for it? Or is it unfixable so that I should move on.

Thanks
Rajesh
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Have you saved the workbook as a native xlsx/m file? If not, you're in compatibility mode, which means you have the same 64K lines you had before.
 
Upvote 0
What is xlsx/m?
When I open the exported file (with excel 2007) I don't see "compatibility mode" above the menu bar I see when I open 2003 files with Excel 2007
 
Upvote 0
xlsx and xlsm (and xlsb) are the native formats for Excel 2007+ files.

How is the name defined?
 
Upvote 0
Name of the file that I am exporting is "CostReport" and its type is "Microsoft Office Excel Worksheet". In my other codes (vba) I am refering this file as CostReport.xlsx
But this export is throwing me off because it won't over write.
 
Upvote 0
Thanks Phil; exporting by deleting file first works just fine. Sometimes easy solutions are hard to get to.

Thanks again
Rajesh
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Access exporting text files with variable file names
Replies
5
Views
940
Micron
M
T
  • Question
Advice on exporting a table to a CSV
Replies
2
Views
1K
Micron
M
B
  • Question
access export excel using vba with conditions
Replies
1
Views
1K
Micron
M
R
  • Solved
Late Binding: extract Access to Excel with formatting
2 3
Replies
22
Views
3K
roelandwatteeuw
R
S
  • Question
Mail Merge Macro Doesn't Connect Refresh
Replies
1
Views
44
StephenBart
S

Forum statistics

Threads
1,214,622
Messages
6,120,585
Members
448,972
Latest member
Shantanu2024

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top