SAP Financial Consolidation Web User Guide

Using an existing Excel workbook to enter data in an EWS schedule

You can create links between your SAP Financial Consolidation schedule and an Excel workbook containing data.

Link syntax

Links use the following syntax:

='<[workbook location]>[<[file name]>]<[sheet name]>'!<[cell reference]>

Example

='C:\Data\Budget\<[Workbook1.xls]>Budget'!C3