Empty Cart

News & Blog

What We Say

Fast Tip Friday: Refresh Data Connections in Excel on Open

Patricia Egen Consulting Fast TipsWe do a lot of spreadsheet reporting against a variety of data environments - for example ACT, Quickbooks, and other SQL vertical applications.  By default, Excel does not automatically refresh the data connections when you open the file.  You need to "turn on" this option.  Note, if the data being imported is a large amount, this will mean it will take longer to open your Excel file - which is why it is turned off by default.

Here's what you do to turn it on.

 

  1. Click on the Data tab in Excel.
  2. Next, in the Connections area, click on the word Connections
  3. Highlight the connection document for the data
  4. Click on Properties
  5. Check the "Refresh data when opening file.
  6. Save the spreadsheet and your data will refresh every time you open the file.
refreshdata

Patricia Egen Consulting, LLC

803 Creek Overlook, Chattanooga, TN 37415
Main office: 423-875-2652 • Arizona office: 480-788-7504 • Florida office: 754-300-2827
support@egenconsulting.com