cancel
Showing results for 
Search instead for 
Did you mean: 

SAC ADDIN EXCEL - Locked menu

freddelain
Discoverer
0 Kudos
191

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!!

Fredericimage.pngimage.png

View Entire Topic
Yogeshwar_M
Explorer
0 Kudos

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 

freddelain
Discoverer
0 Kudos

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.

freddelain_0-1737731120000.png

freddelain_2-1737731522240.png

"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.

 

 

 

Yogeshwar_M
Explorer
0 Kudos

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 😊 

freddelain
Discoverer
0 Kudos

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