Spreadsheet Designer

Sort:
You are not authorized to post a reply.
Author
Messages
Bill Brennenstuhl
Basic Member
Posts: 13
Basic Member

    We are getting ready to move to Cloud Suite and trying to figure out what's the best way to replace some of our current spreadsheet tools we created using Power Query and VBA.  The biggest issue we've found is that after a query is created using Spreadsheet Designer, everytime the spreadsheet is opened, it prompts for the connection, login, and then displays the query properties pane.  Is there a way so that when an end user opens the spreadsheet they don't get all the prompts and can just click Refresh to update the spreadsheet?

    If anyone knows of a better way to create end user tools, I'm open for suggestions.  Can javascript be used to access cloudsuite data?

    Newbie looking for some direction.

    Thanks in advance.

    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      Hi Bill. I understand your pain. I’ve had discussions with the support and developers about being able to control ISD from macros/VBA. There are numerous limitations to using ISD and I would caution against trying to use it for anything programmatic. In particular, two things are a concern. One is multiple sheets. When I have more than a few sheets targeting different business classes, ISD and Excel hang a lot. Also you cannot target the same business class from two different sheets. So doing a multi-sheet upload to journal entries won’t work. Behind the scenes, ISD uses excel tables and keeps renaming the tables so if you try to access them from macros, you’re stuck.

      As for the login, that’s required and the only way I find around it is to disable or uninstall ISD. Quite annoying IMHO.

      You can hide/show the query pane.
      Thanks for using the LawsonGuru.com forums!
      John
      Bill Brennenstuhl
      Basic Member
      Posts: 13
      Basic Member

        Hi John,

        Thanks for the information.  Most of our tools are separate workbooks with single sheets.  It's looking like we'll be either writing custom reports and personalizations if IT let's us or Birst reports.

        Thanks again

        You are not authorized to post a reply.