I’m exploring the ability to copy a Quantrix view and “paste link” into Excel. This will be very useful because it allows us to dump data into Excel from Quantrix without having to go through the export process. Plus, it updates just by opening the Excel file.
When I paste an entire view into Excel, it works fine. However, I can also copy a single cell and paste link into Excel. This gives me an #N/A error in Excel. Any ideas? The formula in Excel looks like it is referencing the correct part of the matrix.
I’ve also experienced the issue you mention:
[quote:10k75vzq]Copy View in Quantrix and Edit -> Paste Special… -> Paste Link -> HTML or Text or Csv in Excel: I get the matrix filled with #VALUE! items.[/quote:10k75vzq]
However if I delete the #VALUE! errors and do it again, strangely it works. Sometimes I just have to try twice before the formulas calculate.
The status of update in Excel is always “Not applicable” for Quantrix links in my experience too.
I have a feeling that the peculiarities around this paste link feature are mostly related to the Windows / Office setup, rather than Quantrix.