Graphics

 View Only
  • 1.  Xcel Spreadsheet Using Drop down Menu

    Posted 20 days ago

    Hi Everyone,

    I'm currently experiencing an issue with an Excel spreadsheet that has a drop-down menu. I've attached the Excel sheet along with the error message I'm encountering. The original spreadsheet wasn't shareable, and I'm wondering if that's causing the problem. We need the spreadsheet open for real-time updates, but when it is open, my crawl only reads the first 5 items in a loop. However, when I exit out of the spreadsheet, my crawl works perfectly fine. Could this be related to the fact that the spreadsheet is not shareable, or is it an issue with the drop-down menus?

    Thank you for your help!



    ------------------------------
    Lazaro Lopez
    TV/DIRECTOR/EDITOR
    MIAMI DADE COUNTY
    ------------------------------

    Attachment(s)

    xlsx
    5452.xlsx   20 KB 1 version


  • 2.  RE: Xcel Spreadsheet Using Drop down Menu

    Posted 19 days ago

    have you tried legacy sharing? 

    https://rossvideo.community/communities/community-home/digestviewer/viewthread?GroupId=199&MID=24452&CommunityKey=91812bfd-9393-4a3f-8a74-7f8035df130e



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 3.  RE: Xcel Spreadsheet Using Drop down Menu

    Posted 19 days ago
    We resolved the issue. We did try the legacy option, but the problem was with the Excel sheet. Once we changed it to "Convert to Range," it worked perfectly.


    Lazaro Lopez, TV Director/Editor

    Communications, Information and Technology Department (305) 375-2432

    miamidade.gov

    Connect With Us on Twitter | Facebook | Instagram | YouTube