Excel for the Web Camera Tool Workaround for Dashboard KPIs in WPS Spreadsheets
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.

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

Use the WPS Spreadsheets Camera Tool for an Exact Desktop Layout
Use this if the Camera Tool layout is essential and you can open the dashboard in WPS Spreadsheets desktop instead of the web.
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. Download and install WPS Office: Go to the WPS Office download page and install WPS Spreadsheets on your computer.
- 2. Open your Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and browse to the Excel dashboard file.
- 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. 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. 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.

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.




