2 weeks ago
Hi all,
I 've to update an excel file with SAC Addin formulas but all menus in the Designer are grayed (locked) and I can't change anything. (add members in filter, delete or create new Datasource, etc ...)
This excel file was created by someone who has lived our company.
Who know how unlock the menus ?
I Hope it is possible !!
Thanks in Advance!!
Frederic
Request clarification before answering.
Hi @freddelain,
These might be the reason check if you have permission to edit or not.
1.Check you have read or write permission for specific model level and story level as you mentioned these is not you created.
2. Check for Data Locking:
Sometimes, a data source connected to the model may also be locked for editing. Ensure that the data source itself isn't locked or restricted. in model level
Kindly upvote if you find it helpful!
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Yogeshwar_M,
Thanks for your answer
I have the read and write permission on the model , I can create my own Excel file with formulas et my own data sources.
"Sometimes, a data source connected to the model may also be locked for editing.Ensure that the data source itself isn't locked or restricted. in model level "
Where can I check this right access ?
Thanks
F.
Hi @freddelain ,
To check data lock 🔒,
Go to your SAC tenant select Modeler option select your preferred model
Navigate to the Model:
On top it shows lock 🔒 option
If data lock 🔒 option is visible then your data is Lock.
Open the Data Locking Tab:
In the model's settings, look for the "Data Locking" tab.
The Data Locking tab will display any active locks on the data. You can see which users or roles have locked specific data ranges and verify if any locks might be causing issues.
Manage Locks:
If needed, you can manage or release locks. You may need the appropriate permissions to make changes to data locks.
Thanks 😊
Hello @Yogeshwar_M,
I know how un/locking data.
I thought you spoke about of a specific link between the model and the "data source" in excel file.
The connection with the model works, I can retrieve data but I can't change anything in datasource setup with the add-in.
I think the problem is that I'm not the owner of the excel file nor the owner of the datasource...
Thanks for all.
Frederic
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.