• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Lydon Solutions

Lydon Solutions

Construction Project Management Software Solutions

  • Construction Viz
  • Services
    • Business Consulting
    • Professional Services
    • Microsoft 365 Managed Services
    • Government Agencies
  • Company
  • Events
  • Blog
  • Careers
  • Contact
  • Search
  • Free Consultation
Show Search
Hide Search
Jeff Lydon

Jeff Lydon, the president and founder of Lydon Solutions, has over 20 years of experience in construction project management, project controls, and product management across multiple industries, including civil/environmental, manufacturing, healthcare, and utilities.

Export to Excel – Tips from the Field

February 16, 2016 Tips from the Field

Learn how to export your project data from SharePoint to Excel and keep it automatically up-to-date in this installment of Tips from the Field.

You and your project team probably share Excel lists and forms all the time as email attachments. But hunting out attachments in your inbox is a pain. And you never can be sure everyone is seeing the latest version.

Here’s a way to stop drowning in email attachments.

Use SharePoint to export a list or form to Excel and share it with your team for reporting or analysis. The spreadsheet now automatically has a connection back to SharePoint. This means that users can easily see the latest data from Excel with a simple click. Read on to see how it works.

Export to Excel from SharePoint

First, use the Export to Excel function in SharePoint. Here’s how:

1.       Select an item in a SharePoint List

2.        Click on the Library tab and then select Export to Excel in the Ribbon

3.       A New Workbook will be created in Excel. You can save the spreadsheet and share the file with your team.

Keep your spreadsheet up-to-date

The added value of the Export to Excel function is that the spreadsheet maintains the connection back to SharePoint. A user can simply refresh the data connection in Excel and all of the SharePoint List data will be updated automatically with the latest data.

Here’s how:

  1. Open the spreadsheet in Excel.
  2. Go to the DATA tab in the ribbon.
  3. Click Refresh All to update the spreadsheet with all the latest data from SharePoint.

Want more tips and tricks for construction project management professionals?

Our new Tips from the Field series will feature handy information for construction project managers.

Subscribe to our newsletter to get our latest tips and tricks delivered directly your inbox.

[contact-form-7 id=”1510″ title=”Newsletter – Subscribe”]

Related Posts

Murph Challenge 2022
Company News | June 23, 2022

We Completed the 2022 Murph Challenge

Read More >
Microsoft News | May 18, 2022

What does Windows 365 Cloud PC mean for construction? – Part 2

Read More >
Microsoft News | May 12, 2022

What does Windows 365 Cloud PC mean for construction? – Part 1

Read More >

Primary Sidebar

Search Blog

Recent Posts

Murph Challenge 2022
Company News | June 23, 2022

We Completed the 2022 Murph Challenge

Microsoft News | May 18, 2022

What does Windows 365 Cloud PC mean for construction? – Part 2

Microsoft News | May 12, 2022

What does Windows 365 Cloud PC mean for construction? – Part 1

Company News | April 6, 2022

Are you ready for the Murph Challenge?

How-To | March 30, 2022

Welcome to Microsoft 365 for Construction. Where We Are Going, There Are No Roads

How-To | March 21, 2022

Track construction project issues and tasks using Microsoft Lists

Footer

About

Lydon Solutions is a WBE consulting group specializing in construction project management software solutions using Microsoft SharePoint.

Learn more >

Products & Services

  • Construction Viz
  • Professional Services
  • Business Consulting
  • Microsoft 365 Managed Services
  • Government Agencies

News & Events

  • Events
  • Blog

Company

  • About
  • Careers
  • Contact Us

Join our Mailing List

  • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
  • This field is for validation purposes and should be left unchanged.
Lydon Solutions

© Lydon Solutions

  • Sitemap
  • Privacy
  • Cookies
  • Terms of Use
  • Disclaimer