United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
tkelly_uk
Level 3
posted
‎May 10, 2020 09:06 PM
last updated ‎May 10, 2020 1:06 PM

Why is there a hidden string in reports exported to Excel

I'm using UK QuickBooks Desktop Pro 2018 on Windows 10. When I export a report -- a GL reports for example -- to Excel, and then try to open that Excel file on a Mac, I get an error about it not being compatible. After a lot of hunting and debugging I've managed to track it down to the fact that for some reason when Quickbooks creates the Excel export it inserts some hidden objects into the Excel file. In particular, it inserts a couple of ActiveX Controls of type TextBox and those aren't tolerated by the macOS version of Excel. If I remove those, Excel on the Mac no longer has an issue and the file opens fine.

 

Can anyone explain:

  1. Why are those ActiveX Control objects there at all; what are they for?
  2. Why are they hidden? and
  3. Why does one of them contain a string of over 10,000 characters? (It's not completely random, but it's clearly not intended to be human readable).

thanks.

 

P.S. My macOS, Windows10, and Excel on both platforms are all current versions and up to date as far as patches and updates are concerned. 

0 Cheers
Cheer
Reply Join the conversation
1 REPLY 1
IntuitLily
Moderator
Moderator
‎May 10, 2020 10:51 PM

Why is there a hidden string in reports exported to Excel

Thank you for posting your question to the Community, @tkelly_uk.

 

Let me share some insights about ActiveX control in QuickBooks. ActiveX control in Internet Explorer is necessary when you export your data. Also, the objects are part of the Desktop plugin when using Excel. The error you're experiencing may be caused by the ActiveX file being corrupted and when this happens, all you need is uninstall it to fix the issue.

 

It seems that the objects are hidden in purpose so that it'll load smoothly when processing the data. Since this is the back-end programming side of things, it'd be best to contact Microsoft directly to learn more about why an ActiveX control is initiated.

 

You can always drop by here if you have other questions or concerns. The Community is open 24/7 if you need further assistance. Take care and enjoy the rest of your weekend.

0 Cheers
Cheer
Reply Join the conversation
Featured
Get started with QuickBooks Online
Ready to get started with QuickBooks Online? This walkthrough guides you th...
Read more

Need to get in touch?

Contact us