ODS Excel output has errors in file

[jimbarbour]

ODS is a wonderful tool, but sometimes it can drive you crazy.  The older ExcelXP destination put out XML that you could (and sometimes had to) manually read and correct the problem.  It's a little more reliable with the newer Excel destination, but when you do have a problem, it's tricky because you can't typically just open it in Notpad.exe and see what's wrong.

A shot in the dark:  Take the spaces out of your sheet name.  Replace them with underscores.  If that doesn't work then maybe @Cynthia_sas or @Vince_SAS might be of more assistance.

Jim

[RyanJB]

Unfortunately, removing the space in the sheet name did not fix the error. Thanks for your response, though!

[jimbarbour]

Told ya it was a long shot. 

Hmm.  Well, let me think about it.  These things are at least in my experience difficult to debug.

Jim