Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    9

    Unanswered: Linking cells: open source to update values

    Hi there,

    I created a source file (.csv) that contains two columns and several rows. This source file is filled (updated) by a SQL process that runs everyday.

    The source file is input for a report in Excel. I would like to automatically update the Excel report when it is opened. However, although it looks like I linked the correct file, worksheet and range, I can only update the Excel report after I manually open the source file. But that's not what I want, I don't want to see the source file.

    Anyone?

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    Zimon,

    I see this was posted a while ago but no answer yet.

    Rather than link to the source file (with formula), use an Excel query table with setting "Refresh data on file open" enabled. Update will then be quick & seamless - and no VBA either. Refer Excel menu path Data, Import External Data, New Database Query

    (You might even be able to eliminate the csv file altogether and put the SQL straight into the Excel query table, if the SQL is not too complex and access is available to the database from Excel.)

    If you'd like further info, please post again.

    regards,
    Fazza
    Last edited by Fazza; 02-20-06 at 02:33.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •