Office Settings & Configuration

How to Automatically Update PowerPoint Data from Excel with Different Formatting

Ayan Masood Oct 22, 2026 868 views

Question details

The user needs to automatically update a PowerPoint slide with Excel data while applying a different visual format from the original Excel source and another linked slide.

How to Automatically Update PowerPoint Data from Excel with Different Formatting

Product: PowerPoint / Excel
Device & OS: not provided
Scenario: Creating a presentation where multiple slides display the same underlying Excel data, but require different, customized layout and formatting designs that update automatically.
Observed behavior: Pasting as a linked Microsoft Excel Worksheet Object updates perfectly but retains the original Excel formatting. PowerPoint cannot natively synchronize a second, custom-formatted slide with the first slide without resetting styles or requiring manual updates.

Before you start

Ensure both your source Excel workbook and your PowerPoint presentation are saved in the same local folder or trusted cloud directory to prevent your data links from breaking.

Solution 1Recommended

Use Paste Special with HTML Format or Unformatted Text

Instead of pasting as an Excel Object, pasting the linked data as text or HTML allows you to apply custom PowerPoint formatting that persists even after the data updates.

When you use Paste Link > Microsoft Excel Worksheet Object, PowerPoint embeds a window to Excel, forcing the slide to use Excel's native formatting. By pasting the link as HTML or Unformatted Text instead, PowerPoint treats the incoming data as native text, allowing your custom slide formatting to remain intact during automatic updates.

Copy the Excel Data

Open your source Excel file, highlight the specific data range you want to display, and press Ctrl+C (or right-click and select Copy).

Access Paste Special in PowerPoint

Navigate to your custom-formatted slide in PowerPoint. On the Home tab, click the drop-down arrow below the 'Paste' button and select 'Paste Special'.

Select Paste Link

In the Paste Special dialog box, select the 'Paste Link' radio button on the left side.

Choose the Text Format

Select 'HTML Format' or 'Unformatted Text' from the list of options, then click OK.

Apply Custom Formatting

Highlight the newly pasted text and apply your desired PowerPoint fonts, colors, and layout. When the Excel data changes, the text will update without overriding these visual settings.

Use Paste Special with HTML Format or Unformatted Text

Formatting Preservation: Using Unformatted Text ensures the linked data completely adopts the destination text box's style.

Solution 2

Use a VBA Macro to Synchronize Formatted Slides

If complex structural changes are required, use a VBA script to pull data from the Excel source and populate shapes on your differently formatted slide.

Smart Office Productivity

Easily Link and Format Excel Data with WPS Office

WPS Office provides seamless data linking between Spreadsheets and Presentation. You can effortlessly update your slides from source data while utilizing rich, customizable formatting tools that keep your presentations looking professional.

1. Copy Source Data: Open your data in WPS Spreadsheets, select the desired cells, and copy them.
2. Use Paste Special in Presentation: Switch to WPS Presentation, navigate to your target slide, click the arrow under 'Paste' on the Home tab, and choose 'Paste Special'.
3. Link as Formatted Text: Select 'Paste Link', choose 'Unformatted Text' or 'HTML Format', and apply your custom slide styles.
4. Update Links Easily: Whenever your Spreadsheet data changes, your WPS Presentation will automatically prompt you to update the links, preserving your custom design.

Seamless data synchronization between Spreadsheets and PresentationHighly compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formatsRich and intuitive formatting tools for customized slide designsLightweight software with a familiar, easy-to-use interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does my linked Excel data lose formatting when updating in PowerPoint?

If you paste the link as a 'Microsoft Excel Worksheet Object', PowerPoint relies on Excel's rendering engine to display the data, meaning it will always mirror the source Excel formatting. To keep PowerPoint-specific formatting, you must paste the link as text or HTML.

Can I link multiple PowerPoint slides to the same Excel file?

Yes, you can copy the same Excel data and use Paste Special > Paste Link on as many separate PowerPoint slides as you need, applying different link formats to each if necessary.

How do I force PowerPoint to update all Excel links at once?

Go to File > Info, look for 'Related Documents' in the bottom right corner, and click 'Edit Links to Files'. Select all the links in the dialog box and click 'Update Now'.

Is there a way to link one PowerPoint slide directly to another?

No, PowerPoint does not have a native feature to link content from one slide to another so that they update automatically. Both slides must individually link back to the original source file (like Excel) to achieve synchronized data.

Office App Problems