Copying Spotlight Formulas to Word using Copy Formulas
  • 1 Minute to read
  • Dark
    Light
  • PDF

Copying Spotlight Formulas to Word using Copy Formulas

  • Dark
    Light
  • PDF

Article summary

  1. Begin by opening and running the View or Report in SpotlightXL containing the data you want to copy to Word. Views are run from the Analyze menu. Reports are run from the Report menu.

    Graphical user interface, application, table, Excel

Description automatically generated

  2. Highlight the portion of the View or Report that you want to copy to Word.

    A screenshot of a computer

Description automatically generated with medium confidence

  3. Click the More menu, then Copy Formulas.

    Note:
    Spotlight uses the power of user-defined functions to connect Excel, PowerPoint, and Word to Dynamic Planning. All data and metadata from Dynamic Planning are represented in formulas, just as they are with Excel-based Reporting.

    Graphical user interface, text, application

Description automatically generated

  4. Open Word and select the page that you want to paste the data into.

  5. On the SpotlightWord ribbon, click Paste Formulas.

    Graphical user interface, application, Word

Description automatically generated

    The formulas are pasted into a table in the document.

    Table

Description automatically generated

  6. On the SpotlightWord ribbon, click Refresh. The #REFRESH data cells are then filled in.Table

Description automatically generated

    If you have multiple pages and open documents with data from Dynamic Planning, you can use Refresh All Open Reports to refresh all pages and open documents at once. This is similar to how reports are refreshed in Excel-based Reports.


Was this article helpful?