Graphics

 View Only
  • 1.  Datalinqing a excel sheet over the network

    Posted 2 days ago

    Hi everyone, I have a question. Can you use Data Link to connect an Excel spreadsheet over a network, or is it limited to just the local drive? The local drive works great using the original method.

    Here are my steps when creating a new Excel sheet that is not on the local drive: I enter the network drive's location in the Excel sheet to point to it, and at the end of the location, I add \Bcc Crawl 2.xlsx, but I can't see the agenda items for the meeting.

    For example, using the original method, I entered: E:\XPression Projects\Misc\Bcc Crawl.xlsx and it worked perfectly. With the new method, I am using: Z:\\ecsfs3\CCED\COMGraphics\External Shares\Agenda QR Codes\Sample Excel File\Bcc Crawl.xlsx, but it says the file name is incorrect. Can anyone help me figure out what's going wrong?

     Thank you!



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


  • 2.  RE: Datalinqing a excel sheet over the network

    Posted 14 hours ago

    Can move the datalinq server to the machine with the excel and then connect xpression to the datalinq over network?



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



  • 3.  RE: Datalinqing a excel sheet over the network

    Posted 13 hours ago
    So, I can't just use the path to access the files that way? I'm using the same path to link PNG files, and that works fine. Is it possible that it can't open Excel files if they're on a network drive?

    Lazaro Lopez, TV Director/Editor

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

    miamidade.gov

    Connect With Us on Twitter | Facebook | Instagram | YouTube








  • 4.  RE: Datalinqing a excel sheet over the network

    Posted 13 hours ago

    Does the machine with datalinq on have excel installed? 



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



  • 5.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago
    Its a shared drive. 






  • 6.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago

    I understand but is excel installed on the machine that is running datalinq?



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



  • 7.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago
    Yes

    Lazaro Lopez, TV Director/Editor

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

    miamidade.gov

    Connect With Us on Twitter | Facebook | Instagram | YouTube








  • 8.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago

    ok, I was just checking because its an xlsx files require that where as older forrmat (xls) do not so people don't always realise. 



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



  • 9.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago
    I'm sorry, I don't know if it does. Im reaching out to the other dept.

    Lazaro Lopez, TV Director/Editor

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

    miamidade.gov

    Connect With Us on Twitter | Facebook | Instagram | YouTube








  • 10.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago

    I just did a test, I am also having issues with xlsx over network drive but xls works fine. 

    Any chance you can use xls format or you need the newer format? 



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



  • 11.  RE: Datalinqing a excel sheet over the network

    Posted 12 hours ago
    I'M TRYING to get a xls format to try. What other format do you recommend? Thank you

    Lazaro Lopez, TV Director/Editor

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

    miamidade.gov

    Connect With Us on Twitter | Facebook | Instagram | YouTube