Output to Excel error: Removed Records: Formula from /xl/calcChain.xml part
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am replacing one sheet of many in an Excel workbook.
A new sheet for each of 64 workbooks, every month.
I use the "Overwrite Sheet or Range" option in Output.
It all works fine, except that when anyone opens the workbook they get this error message:
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
Excel asks if you want to proceed with repairs, and if you do, everything is fine.
But this error message makes us look bad to clients, as if we've produced something defective, and it takes up users' time to say, "Yes, go ahead."
Can I output a sheet to Excel without having this time bomb in the Excel file?
Thanks.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Do these help?
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-to-Excel-error/td-p/492...
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-from-xl-calcChain-xml-...
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-Overwrite-issues/td-p/10...
- https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/quot-Removed-Records-Cell-Info...
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Newt
The source for that error stem from the fact that when you are opening excel there is a text that containing symbols that in excel are been used in formula, can be =, <, > , +, and more. So, If you have these symbols as part of your data as text, when you open excel it try to calculate that formula. If you have this type of scenario, the why to handle it, in excel, would be to add an apostrophe at the of the text, that will indicate to excel that this is a text format and it will not try to convert it into a formula.
