Office Compatibility Issues

Excel for the Web Camera Tool Workaround for Dashboard KPIs in WPS Spreadsheets

Khadija KhanKhadija Khan Nov 13, 2026 873 views

Question details

The user needs a web-compatible way to display dashboard KPI cards because Excel for the web does not support the Camera Tool or linked-picture interactions.

Excel for the Web Camera Tool Workaround for Dashboard KPIs
Product
WPS Spreadsheets and Microsoft Excel for the web
Device & OS
not provided
Scenario
The user manages an Excel dashboard that relies on linked PivotTable pictures or Camera Tool snapshots and wants the KPIs to remain visible and current in the browser.
Observed behavior
In Excel for the web, Camera Tool linked pictures are not supported, so KPI cards may appear as static images, break, or fail to refresh.
Before you start

Open the affected workbook in WPS Spreadsheets and identify which KPI cards come from Camera Tool snapshots or linked PivotTable pictures. Confirm that the underlying PivotTable data is available before rebuilding those cards with formulas and conditional formatting.

Solution 1Recommended

Rebuild KPI Cards with Formulas, Conditional Formatting, and Charts

Use this method when you need dashboard KPI cards that work in Excel for the web and WPS Spreadsheets without relying on Camera Tool linked pictures.

Excel for the web and WPS Spreadsheets can evaluate worksheet formulas and conditional formatting, so KPI cards built from cell references are more compatible than Camera Tool snapshots.

1
Select the KPI result cells

Open the workbook in WPS Spreadsheets and select the worksheet cell where the first KPI value should appear. Enter a formula such as =GETPIVOTDATA(...) or a direct reference like =DashboardData!B5 that targets the PivotTable result.

2
Add comparison and trend formulas

In adjacent cells, enter formulas for change or variance, for example =Current-Previous and =IF(Current>Previous, "▲", "▼").

3
Apply conditional formatting icons or arrows

Go to Home > Conditional Formatting > Icon Sets or Highlight Cells Rules, then choose arrows, traffic lights, or color scales. Set the rule based on the KPI value or change cell.

4
Add charts or shapes for visual cards

Select the KPI range, go to Insert > Chart, and choose a column, line, or bar chart. Use Insert > Shapes to add card containers that remain web-compatible.

5
Save and test in Excel for the web

Save the workbook as .xlsx, upload it to OneDrive or SharePoint, and open it in Excel for the web to verify that the KPI cards refresh from the data source.

Rebuild KPI Cards with Formulas, Conditional Formatting, and Charts
KPI cards now update from data: The rebuilt cards no longer depend on unsupported linked pictures or Camera Tool snapshots.
Excel for the web compatibility workaround

Build Web-Compatible KPI Dashboards with WPS Spreadsheets

Open your Excel dashboard in WPS Spreadsheets and rebuild KPI cards using formulas, conditional formatting, and charts so they work in the browser. For desktop-only layouts, the WPS Camera tool provides familiar linked-picture behavior without requiring Microsoft Excel.

  1. 1. Download and install WPS Office: Go to the WPS Office download page and install WPS Spreadsheets on your computer.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and browse to the Excel dashboard file.
  3. 3. Rebuild the KPI cards: Use formulas to reference PivotTable results, then apply Home > Conditional Formatting icon sets and Insert > Chart or Shapes for each card.
  4. 4. Add a Camera snapshot if the exact desktop layout is required: Select the source range and go to Insert > Camera, then place the linked picture on the dashboard.
  5. 5. Save and share: Save the file as .xlsx, upload it to OneDrive or SharePoint if needed, and open it in Excel for the web to confirm the KPI cards display correctly.
Replaces linked-picture KPI cards with web-compatible formulas and conditional formatting.Uses the WPS Spreadsheets Camera tool for live desktop dashboards.Opens and saves Excel .xlsx and .xlsm files with full format compatibility.Familiar Office-style ribbon and low system resource use make migration easy.Free download with no subscription required for core spreadsheet features.
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel for the web support the Camera Tool?

No. Excel for the web does not support the Camera Tool or linked-picture interactions used by some desktop Excel dashboards. You can rebuild KPI cards with formulas, conditional formatting, and charts, or open the workbook in a desktop spreadsheet application such as WPS Spreadsheets.

Can WPS Spreadsheets open my Excel KPI dashboard without losing Camera Tool snapshots?

WPS Spreadsheets opens .xlsx and .xlsm workbooks and provides a Camera tool on desktop, so you can keep linked pictures for local use. However, those linked pictures may not behave the same way in Excel for the web.

How do I create KPI cards that update automatically without the Camera Tool?

Use formulas such as GETPIVOTDATA or direct cell references to PivotTable results, then add conditional formatting icon sets, arrows, and colors from Home > Conditional Formatting. This works in WPS Spreadsheets and Excel for the web.

Which conditional formatting options are best for KPI dashboards?

Icon sets, color scales, and data bars are useful. In WPS Spreadsheets, select the KPI cells, go to Home > Conditional Formatting, and choose Icon Sets or Highlight Cells Rules to show positive, negative, and neutral changes.

Can charts replace Camera Tool KPI cards?

Yes. Charts based on worksheet cells are supported in Excel for the web and WPS Spreadsheets. Select the KPI source range and go to Insert > Chart to create a column, line, or bar chart, then place it on the dashboard.