My Oracle Support Banner

Is It Possible To Stop Data Recalculation When Submit Data In Smart View? (Doc ID 2620303.1)

Last updated on DECEMBER 28, 2019

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 19.12.73 and later
Information in this document applies to any platform.

Goal

Is it possible to stop data recalculation when Submit Data in Smart View?

The Calculation Options of Formulas in Excel is set to "Manual". However, data is recalculated when Submit Data in Smart View.

1. Set Calculation Options of Formulas in Excel to "Manual".
2. Set a cell in Sheet1 equal to the A1 cell in Sheet2. (The value of A1 cell in Sheet2 is "123".)
    The value of Sheet1 is "123".
3. Change "123" to "666" in Sheet2.
4. Since the Calculation Options of Formulas in Excel is set to "Manual",
    "666" is not reflected in Sheet1. Sheet1 still displays "123".
5. Execute "Submit Data".
6. "123" is sent to the server side.
    "666" is reflected on Sheet1 by data recalculation.

 

 


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.