Difference between revisions of "About the dZMirror"
From dataZoa Wiki
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
<div style="margin-left: 2em;"> | <div style="margin-left: 2em;"> | ||
<div> | <div> | ||
| − | When a dataZoa table is mirrored in a user's spreadsheet, each cell in the table becomes an actual cell in the spreadsheet. Because | + | When a dataZoa table is mirrored in a user's spreadsheet, each cell in the table becomes an actual cell in the spreadsheet. Because all of the dataZoa cells [[Automatic Updates|update automatically]], formulas in the spreadsheet update automatically as well. |
</div> | </div> | ||
<div> | <div> | ||
| Line 10: | Line 10: | ||
</div> | </div> | ||
<div> | <div> | ||
| − | You can download the dZMirror add-in [https://www.datazoa.com/ | + | You can download the dZMirror add-in [https://www.datazoa.com/about/dzmirror.asp here]. |
</div> | </div> | ||
</div> | </div> | ||
<br> | <br> | ||
| − | <div class="imgGlyph24 imgIdea"></div> Rather than copying values in and out of spreadsheets, share the "mirror" link. No time-lag, no copying mistakes, no "version confusion". | + | <div class="imgGlyph24 imgIdea"></div> Rather than copying values in and out of spreadsheets, host your data in dataZoa and share the "mirror" link. No time-lag, no copying mistakes, no "version confusion". |
<div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | <div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | ||
| Line 23: | Line 23: | ||
[[Category:Displays]][[Category:Definitions]] | [[Category:Displays]][[Category:Definitions]] | ||
[[Category:Circulating]] | [[Category:Circulating]] | ||
| + | [[Category:Time_Savers]] | ||
Latest revision as of 11:01, 28 August 2018
The dZMirror is an add-on for Microsoft Excel that links the cells of an Excel spreadsheet to the cells of a tabular dataZoa display.
When a dataZoa table is mirrored in a user's spreadsheet, each cell in the table becomes an actual cell in the spreadsheet. Because all of the dataZoa cells update automatically, formulas in the spreadsheet update automatically as well.
The "dZMirror"
icon sits in the footer of tabular displays enabled for the display. Anyone viewing your display can use it download the add-in and mirror it into their own spreadsheet.
You can download the dZMirror add-in here.
If you allow a display to be posted publicly, be sure that related series are marked as public. When a private series is viewed outside its account, and its title shows as "Unavailable" its values show "NA."
