Forum Discussion
Solved
Circul
Circular Reference : Hi there Team
iv copied and pasted info and used the circular reference, and now i need to secure the worksheet independent of the source, yet retain all info
Select the relevant range on the sheet with the formulas.
Copy it.
While the same range is still selected:
Click the lower half of the Paste button on the Home tab of the ribbon.
Select Values from the drop-down menu.
4 Replies
Select the relevant range on the sheet with the formulas.
Copy it.
While the same range is still selected:
Click the lower half of the Paste button on the Home tab of the ribbon.
Select Values from the drop-down menu.
Hi There HansVogelaar pl could you explain it in simpler terms as im new to xcell, BTW thanks for the reply .
I assumed that you want to "fix" a worksheet so that the values do not change anymore.
Is that correct?
If not, please explain what you want instead.
