AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Velixo Reports for ...
No workbook open
 
Notifications
Clear all

Questions No workbook open

 
Velixo Reports for Excel and Acumatica (Financial Report Writer)
Last Post by Gabriel Michaud 8 years ago
4 Posts
3 Users
1 Reactions
2,444 Views
RSS
fozzie
Posts: 34
 fozzie
Topic starter
December 21, 2017 5:33 pm
(@fozzie)
Trusted Member
Joined: 9 years ago

I got an email from someone with a Velixo Reports Excel file attached.

When I try to open the Excel file and click Acumatica -> Refresh All, I get the following error message:

No workbook open.

Does anyone know why this happens?


3 Replies
John Doe Updated
Posts: 3193
 John Doe Updated
Admin
December 21, 2017 5:44 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Fozzie,

When you open Excel files from an email or download one from the internet, Excel goes into protected mode which you can see in the yellow bar on the top of your screenshot. When this happens, some Excel Add-Ins like Velixo Reports get blocked by Excel.

 

First, you need to save the Excel file to your computer. I'll explain why later.

Then, click the Enable Editing button on the yellow bar:

 

But here's where it gets weird. You're going to get a bizarre error message:

Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

Exception from HRESULTS: 0x800A03EC.

 

Then you click Continue like in the screenshot above, but you get get caught in an infinite loop.

So make sure you close Excel after clicking Continue to get out of the infinite loop, then re-open the file. This is why it's important to save the Excel file to your computer so Excel will remember that you marked Enable Editing on the file. If you re-open the file from email, it will get protected again, and you go through the same thing.

After you re-open the Excel file from your computer, it should open in unprotected mode and it should work.


Reply
fozzie
Posts: 34
 fozzie
Topic starter
December 21, 2017 5:45 pm
(@fozzie)
Trusted Member
Joined: 9 years ago

Thanks @timrodman, that worked.

Kind of weird that you have to save the file to your computer every time, but it makes sense why that error happens.


Reply
Gabriel Michaud
Posts: 60
 Gabriel Michaud
December 21, 2017 5:48 pm
(@gabriel)
Trusted Member
Joined: 5 years ago

Thanks Tim. This is a known issue and my plan is to improve error handling to show a proper error message to the user and avoid the infinite loop.


Reply
John Doe Updated reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 7 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×