Formula vs link - best practice?
We are new to Workiva and are setting up our working papers at the moment. I see that there are two options in order to reference data from one spreadsheet section to another section - by formula reference, or by linking.
Is there a best practice on which to use, if we are just wanting to "link" the cell data from one sheet to another sheet?
Or are both the same?
-
Hello Shera,
We recommend using cross-sheet formulas for value references inside the spreadsheet; and using links for cross-document references.
Let us know if you have any additional questions!
0
Thanks for your response Courtnie! May I understand the underlying reasons why cross-sheet formulas are recommended for value references inside a spreadsheet?
In my past experience with Workiva in other companies we've always used links for everything, so cross-sheet formula for value references is new to me, and I'd like to learn more.
0
I reached out to our spreadsheet experts to provide you some more details!
In regards to your past experience - this may be due to the fact that Classic did not have the ability to perform cross-sheet formulas. Any intra-workbook linking had to use linking in those days. Next Gen has the ability to do both!
Our experts stated that cross-sheet references are orders of magnitude faster/less resource intensive than links. Additionally, links within spreadsheets count to your link limit (70,000 links - hard limit). Linking within spreadsheets is simply not best practice in terms of scalability (link limit) or sustainability (what if the format of the sheet you are linking to changes/gets overridden).
I hope this helps!
1U moet u aanmelden om een opmerking te plaatsen.
Opmerkingen
3 opmerkingen