Please note that if you make any changes to your date range and want that to be reflected in your worksheet, you will need to re-run the Customizable Data Export before refreshing your Excel worksheet. You can then periodically refresh your worksheet using the "Refresh All" option on the data tab:. You can then copy/paste this XML link from the page confirming the report has finished running:. Ran the report to make sure that the criteria used is the most up-to-date. Created a Customizable Data Export with a saved name:. This guide has more information about optimal settings for working with ClickTime and may also be a helpful resource.Īfter making sure you have the appropriate "Legacy" XML Linking options enabled (explained below), please make you have done the following before using the XML link that ClickTime provides: Excel pulls the data from ClickTime via port 443 (a standard HTTPS web protocol) when the end-user opens and uses the Excel file - if you are experiencing issues you believe are related to your firewall, please check with your local network Administrator for assistance. There should not be any issues with using the XML linking process behind a firewall, as ClickTime does not push data to the file directly. Some customers have also asked about using XML linking when their local network is behind a firewall. xlsx format, please contact ClickTime Support and we can provide you with another method to populate your worksheet that can be saved in. xlsx format) if you need to refresh a worksheet with updated data. Due to a current Microsoft issues, you will want to save files in. This feature is only available to Corporate or Enterprise accounts. Only one link to ClickTime can be established per workbook. The Mac-based version of Excel was not designed to support data linking. Import Instructions for Excel 2013 or 2016 Import Instructions for Microsoft Excel 365 
For assistance generating a data link, please see the Data Linking Overview guide here.
Data Linking starts with the Customizable Data Export Report - general information on using that report is available in the Customizable Data Export Overview Guide here.
#Break link to documents in excel for mac how to#
This guide will cover how to use the data link you generate from a Customizable Data Export with the different versions of Excel.
0 kommentar(er)
