Domo for Office - Excel: Refresh causes all cards to move to cell A1?

SharonK
SharonK Member
in Connectors

Help! I'm creating an invoice based on cards we've created in Domo - with the ability to update the data each month by selecting the month through a document level filter. There is a card for the invoice #, the invoice period, and a table of what has been purchased. These cards are arranged on an Excel sheet which has other data. In the past, if I refreshed all or refreshed a card, it would stay where I set it up.

With the latest update of Office 365, Excel Version 2501 (Build 18429.20044 Click-to-Run), after a refresh all the cards move to cell A1. They move regardless of the setting "Don't move or size with cells."

Any ideas on how to have the cards remain where they belong?

THANK YOU!

-Sharon

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    I'd recommend logging a ticket with Domo Support as this sounds like a bug with the Domo Office plug-in which they control.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • SharonK
    SharonK Member

    Thank you!

    I ended up with a better solution - instead of pulling cards into Excel, I pulled in the raw data (with the filters) and then wrote formulas to pull the key pieces into the actual cells where I wanted them. No need to mess with sizing any longer, and I can keep the same font for the whole sheet. Works quite well, and gives us the option to manually add lines to the invoice (for corrections/adjustments) as needed.

    I also submitted Case: 05897059.

Categories