AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Excel Talk
    • Blog
    • Forums
  • Courses
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Velixo Reports for ...
No workbook open
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions No workbook open

    Last Post
RSS

fozzie
Posts: 34
 fozzie
Topic starter
December 21, 2017 5:33 pm
(@fozzie)
21-50 Posts
Joined: 5 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
Tim Rodman
Posts: 2900
 Tim Rodman
December 21, 2017 5:44 pm
(@timrodman)
Over 200 Posts
Joined: 7 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)
21-50 Posts
Joined: 5 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: 55
 Gabriel Michaud
December 21, 2017 5:48 pm
(@gabriel)
51-100 Posts
Joined: 2 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
Tim Rodman liked
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
2,145 Topics
9,532 Posts
10 Online
1,679 Members

Latest Post: Want to create a Generic Inquiry to manage files that are attached to sales orders Our newest member: Lynn Slottke Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×