SPLICE
New Member
- Joined
- Sep 14, 2014
- Messages
- 1
Hello:
My instructions for this workbook are as follows:
1. Hit refresh in the data tab under add-ins
2. Within formula, fix the zeros by adding Iferror(0,…) and then add one more bracket at the end.
(All of the cells don't call values from other cells, so I am unsure how to reference the current value of the cell, and perform the IFERROR function on values that are zero, and replace those values with "...".
Notes:
I hit the refresh button in the proper worksheet under the DATA tab, and selected "Refresh All".
"Refresh" is grayed so I presume that "Refresh All" would also work.
I don't see any connection information or databases available, so I am unsure if this information was stripped from the sheet?
Notes:
Where can I upload a sample sheet?
My instructions for this workbook are as follows:
1. Hit refresh in the data tab under add-ins
2. Within formula, fix the zeros by adding Iferror(0,…) and then add one more bracket at the end.
(All of the cells don't call values from other cells, so I am unsure how to reference the current value of the cell, and perform the IFERROR function on values that are zero, and replace those values with "...".
Notes:
I hit the refresh button in the proper worksheet under the DATA tab, and selected "Refresh All".
"Refresh" is grayed so I presume that "Refresh All" would also work.
I don't see any connection information or databases available, so I am unsure if this information was stripped from the sheet?
Notes:
Where can I upload a sample sheet?
Last edited: