Categories
- All Categories
- 101 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Oracle import map macro enable xlsm overrides user specific desktop settings

Downloadable import map files from UCM are all set to default as Calculation Options - Manual, which in turn defaults other open excel files to Manual. The Team is working with different shared excel file tools all the time and it gets very tedious and unproductive to constantly check this setting and revert it back to Automatic. Failure to check results in various incorrect calculations (because calculations are not updating) used in BOS and other information.
Is there any way to set the default calculation setting to Automatic such that these files won't override that setting?
Answers
-
Hi,
Welcome to the forum!
Is the question really about Publisher? Are you asking how you could generate Excel files from Publisher with that option?
Or is it a question about something else, more related to Fusion as cloud product?
Based on your answers it will be possible to move the question to the right category if needed, or to point you to the right forum if it's a different community in charge of it.
0 -
Hi Ceresa,
It's more related to Oracle Fusion Product Hub. When we download the import map template file from Oracle Product Information Management, the downloaded Excel file has the calculation option set as 'Manual' in the formula tab which in turn also overrides all the calculation option settings in our local machine and sets them 'Manual' from 'Automatic'.
Excel formulas do not work well when the calculation option is Manual. Is there any way we can change the excel template settings in Oracle Cloud?
0 -
Ok,
This to me doesn't sound like an Oracle Analytics product, but more like a Fusion product.
Therefore you should post your question in the forum covering the Fusion products:
Have a look at the various categories there and try to find the one being the best match for your question.
0