---
title: How to Update a Workbooks ODC
description: Simple steps to updating an OCD
---

[Skip to content](https://fundamentals.theretailscore.com/knowledge/how-to-update-a-workbooks-odc#main-content)

English

Show submenu for translations

[Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en)

![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://fundamentals.theretailscore.com/support-client-view)
- Go to theretailscore.com

 Go to theretailscore.com

 The Retail Score Fundamentals

- There are no suggestions because the search field is empty.

1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en)
2. [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en)
3. [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide)

# How to Update a Workbooks ODC

## Simple steps to updating an OCD

This document will be useful for Test cubes and Cube Migrations.

#### Please follow the steps to update the entire Workbooks ODC connection.

1. Go to the Data tab on your Excel Workbook
2. Queries & Connections  
   ![](https://fundamentals.theretailscore.com/hubfs/image-png-Mar-16-2023-03-13-36-4861-AM.png)
3. Choose Connections under the right-hand side wing popup
4. Right Click on the Connection
5. Properties  
   ![](https://fundamentals.theretailscore.com/hubfs/image-png-Mar-16-2023-03-14-28-4118-AM.png)
6. Definitions
7. Browse
8. My Data Sources![](https://fundamentals.theretailscore.com/hubfs/image-png-Mar-16-2023-03-15-54-5660-AM.png)

9\. This process of updating the ODC may help you reload reports that are having refresh issues.

 

#### Please follow the following steps to update an individual pivot tables ODC

1. Select the Pivot
2. Under the PivotTable Analyze Tab select Change Data Source
3. Choose Connection
4. Browse for More
5. Select the new ODC
6. This process of updating the ODC for an individual pivot table
   
   ![](https://fundamentals.theretailscore.com/hubfs/image-png-Mar-16-2023-03-22-32-5242-AM.png)

- [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started)
    - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help)
- [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started)
    - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides)
- [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content)

    - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help)
- [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content)

    - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger)
    - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters)
    - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics)
- [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started)
    - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help)
- [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content)

    - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis)
- [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en)
- [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content)

    - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases)
- [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content)

    - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about)
    - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up)
    - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started)
- [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en)

[![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en)

theretailscore.com Help Center

Copyright © 2026, the Retail Score