How to Use Capture Data?

Article summary

Did you find this summary helpful?

Thank you for your feedback

In SpotlightXL, navigate to Analyze > Data.
Select a view from the folder structure; the tab displayed will be named Analyze.
Under the More menu on the ribbon, click the down arrow and select Capture Data as SpotlightXL Formulas.
All data items will show as #REFRESH, and cell contents will consist of SpotlightMetadata or SpotlightData formulas.

Note:
Clicking Get Data in the Analyze tab will trigger a warning. If you proceed, it will replace Spotlight formulas with data values from the model.
Copy the entire contents of the Analyze worksheet to a new blank worksheet.
Select Excel Report from the Select Task menu. The menu changes to reflect the options for Excel reports.
Click Refresh.
Note:
If your view uses Display Label, the resulting Excel Report does not display the label initially after conversion. After you click Refresh, the labels appear.

Was this article helpful?