5 replies to this topic

[Imph]

Hello!

 

Please, 

 

How can we join a new worksheet to a locked workflow?

 

Thank's in advance.

[cradhakr]

HI Imph,

 

New worksheet can be added to "Data" workflow. Also, could you please let us  know if your project is being locked? or please share some images and send the request to support@certara.com. 

Note: All data shared with Certara are subjected to confidentiality.

 

Thanks

Mouli

[EvanFrye]

If you have locked a worksheet in Excel to prevent changes to it, you will need to unprotect it first to make any edits or add new data. To do this, click on the ""Review"" tab in the Excel ribbon and click ""Unprotect Sheet."" You may be prompted to enter a password if one was set when the worksheet was locked.
Once you have unlocked the worksheet, you should be able to add a new worksheet and link it to the locked worksheet by using formulas or referencing cells in the original worksheet. Also, Check out worksheetsgo if you need ready worksheets for work with the class.
I hope this helps!

Edited by EvanFrye, 14 March 2023 - 08:33 PM.

[Helmut Schütz]

Here we are talking about Phoenix, not bloody M$ Excel…

[Simon Davis]

Hi Helmut, I haven't used locking of work flows much, but when I have i have typically put the bits I need to lock into a sub-workflow and 'above' that, in the root i have my data links etc.  

 

Does that help ? if not perhaps you can share a bit more about the role of the extra worksheet you are adding to a locked workflow, is it a case of e.g ,merging in treatment/doses before commencing analysis?  again in that case I would have a precursor 'join' or 'merge' that is still open above the locked sub workflow.

Simon.

 

 

Attached Thumbnails

• 

[Helmut Schütz]

Hi Simon,

 

Hi Helmut, I haven't used locking of work flows much, but when I have i have typically put the bits I need to lock into a sub-workflow and 'above' that, in the root i have my data links etc.  

 

Does that help ? if not perhaps you can share a bit more about the role of the extra worksheet you are adding to a locked workflow, is it a case of e.g ,merging in treatment/doses before commencing analysis?

 

Never did it myself. Backstory there.