Specific information regarding Excel functionality
Some standard Excel features are not available or have been adapted so that EWS schedules can be used. For more information on these functions, refer to the Frequently asked questions - Data retrieval section in the Web version of the Financial Consolidation documentation.
Restricted functions
- Drag and drop
- Undo or redo
- Cutting or pasting cells
- Pasting a comment in a cell
- Paste special
- Inserting and deleting a range of cells
- Sorting elements
- Locking cells and totals for spreads
- Spread calculations
- Schedule colors
- Editing a chart
- Entering a formula referenced to another workbook
- Status bars
- Cells containing spread formulas
- Copying or pasting from one sheet to another
- Headers and footers
- Local modeling and merge reports
- Working on more than one sheet at a time
- Hypertext links
- Outlines
- Split
Unavailable functions
- Adding a user macro
- Creating workbooks
- Repeat clear
- Copying cell formats
- PivotTable reports
Technical restrictions
- Deleting a sheet from a workbook
- Working with rows or columns in a schedule
- Opening an EWS schedule that contains local modeling
- Clipboards
Available functions not managed
- Adding a Macro MS Excel4 sheet type
- Defining a spread total calculated from line item details on another sheet
- Customizing toolbars
- Duplicating an Excel sheet