Is there any way of 'locking' the outcome of any excel add-in formulas. For example, I have documents that have many tabs using it and when I provide these to audit, I have to copy & paste over any areas where there is an Iplicit formula because it will show with no values to the auditors.
0 Votes
Gabrielle Day posted
23 days ago
AdminBest Answer
Hi Andrea,
Thanks for posting this. There isn’t a way to lock the results of iplicit formulas in place within the live workbook, as the functions recalculate from iplicit whenever the add-in is connected. Converting them to values is the right approach, but you can make it quicker than copying and pasting individual areas:
Save the workbook under a new name, for example “Audit copy”, so your live version keeps its formulas.
On each tab, press Ctrl+A to select the whole sheet, then Ctrl+C to copy.
Right-click and choose Paste Special > Values (or press Ctrl+Alt+V, then V, then Enter).
Repeat for each tab, then save.
This replaces every formula, including iplicit functions, with its current value, so the file opens with figures showing for anyone without the add-in.
If your auditors only need to review the figures rather than work in the spreadsheet, saving the audit copy as a PDF is another option and avoids the conversion step entirely.
I’d also love to hear from other iplicit users here. If you’ve found a different way of preparing Excel reports for auditors or external reviewers, please share it below.
0 Votes
2 Comments
Sorted by
A
Andrea Sapsfordposted
23 days ago
Thank you for your response. I realise I can just copy and paste whole sheets but I like the auditors to see where totals come from, ie, the rows above or the columns to the left for them to review. I have a lot of formulas that point to information on another tab or workbook so I wouldn't want all those replaced either. This is why I choose to just copy & paste over any Iplicit formula cells.
I would be interested to know what others do in their reconciliations, etc that are provided to auditors.
0 Votes
Gabrielle Dayposted
23 days ago
AdminAnswer
Hi Andrea,
Thanks for posting this. There isn’t a way to lock the results of iplicit formulas in place within the live workbook, as the functions recalculate from iplicit whenever the add-in is connected. Converting them to values is the right approach, but you can make it quicker than copying and pasting individual areas:
Save the workbook under a new name, for example “Audit copy”, so your live version keeps its formulas.
On each tab, press Ctrl+A to select the whole sheet, then Ctrl+C to copy.
Right-click and choose Paste Special > Values (or press Ctrl+Alt+V, then V, then Enter).
Repeat for each tab, then save.
This replaces every formula, including iplicit functions, with its current value, so the file opens with figures showing for anyone without the add-in.
If your auditors only need to review the figures rather than work in the spreadsheet, saving the audit copy as a PDF is another option and avoids the conversion step entirely.
I’d also love to hear from other iplicit users here. If you’ve found a different way of preparing Excel reports for auditors or external reviewers, please share it below.
Is there any way of 'locking' the outcome of any excel add-in formulas. For example, I have documents that have many tabs using it and when I provide these to audit, I have to copy & paste over any areas where there is an Iplicit formula because it will show with no values to the auditors.
0 Votes
Gabrielle Day posted 23 days ago Admin Best Answer
Hi Andrea,
Thanks for posting this. There isn’t a way to lock the results of iplicit formulas in place within the live workbook, as the functions recalculate from iplicit whenever the add-in is connected. Converting them to values is the right approach, but you can make it quicker than copying and pasting individual areas:
This replaces every formula, including iplicit functions, with its current value, so the file opens with figures showing for anyone without the add-in.
If your auditors only need to review the figures rather than work in the spreadsheet, saving the audit copy as a PDF is another option and avoids the conversion step entirely.
I’d also love to hear from other iplicit users here. If you’ve found a different way of preparing Excel reports for auditors or external reviewers, please share it below.
0 Votes
2 Comments
Andrea Sapsford posted 23 days ago
Thank you for your response. I realise I can just copy and paste whole sheets but I like the auditors to see where totals come from, ie, the rows above or the columns to the left for them to review. I have a lot of formulas that point to information on another tab or workbook so I wouldn't want all those replaced either. This is why I choose to just copy & paste over any Iplicit formula cells.
I would be interested to know what others do in their reconciliations, etc that are provided to auditors.
0 Votes
Gabrielle Day posted 23 days ago Admin Answer
Hi Andrea,
Thanks for posting this. There isn’t a way to lock the results of iplicit formulas in place within the live workbook, as the functions recalculate from iplicit whenever the add-in is connected. Converting them to values is the right approach, but you can make it quicker than copying and pasting individual areas:
This replaces every formula, including iplicit functions, with its current value, so the file opens with figures showing for anyone without the add-in.
If your auditors only need to review the figures rather than work in the spreadsheet, saving the audit copy as a PDF is another option and avoids the conversion step entirely.
I’d also love to hear from other iplicit users here. If you’ve found a different way of preparing Excel reports for auditors or external reviewers, please share it below.
0 Votes
Login to post a comment