Office 365 - Access is exporting to Excel with range names

[pliskers]

I'm getting an error when I open Excel files that have been exported from Access in Office 365. In researching this I see that part of the issue may be range names that are coming over in the export. I have NOT checked the box to export formatting. How can I prevent this data (which is being exported as an xlsb format) from being exported to Excel with range names that I don't want?

Thanks in Advance!

 

[pliskers]

The error says :[h=2]Removed Records: Named range from /xl/workbook.bin part (Workbook)[/h]

 

[xenou]

If you want to know why this happens, you'll need to describe your export procedures. Access doesn't have named ranges in it so its not clear why you would be getting this error. However, you may find your workaround is fine too. Personally I also like to export to CSV or text files in many cases.

 

[pliskers]

That's what I did as a workaround. I'm simply using an Access macro with the Import/Export Spreadsheet function, tried with both regular Excel .xlsx and Excel Binary .xlsb options. The export happens, but when I open it I get the error message prompting me to recover whatever data it can. The data appears to be there, and if I re-save it the error goes away after re-opening it. It's very weird. There are no special characters or spaces in the file name.

 

[xenou]

Named ranges are not filenames or tab names. If Excel is removing them then in general I would not expect your data to be affected or the workbook to be unusable.

Is this a brand new workbook you are creating when you do the export?

 

[pliskers]

Yes, it is.

 

[xenou]

Okay. Well in my humble opinion there should be no range names in the workbook so the error can be ignored

 

[james_lankford]

other people with that error have apostrophes or spaces or things in the name
https://stackoverflow.com/questions...ed-range-from-xl-workbook-xml-part-when-tried


or problems with a template
https://github.com/RamblingCookieMonster/PSExcel/issues/54

 

[xenou]

I guess templates are a possibility - it could explain how you could be creating a default workbook (i.e. a new workbook) that has range names in it. Not sure why anyone would do that (I wouldn't think that named ranges belong in templates unless you have a very good reason to do so and know what you are doing). But it's a possible reason.