Hi Amanda
The problem is that when excel opens a file and can’t find the links you use, it puts something like “=WENNFEHLER(SVERWEIS($P8,#BEZUG!,2,0),“Not Found”)$2
On my german computer.
You have to find a version where the link is stll there or adjust the formulas with something like results!resultsa1:…
Cheers
Renger
Von: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] Im Auftrag von Amanda S
Gesendet: Friday, January 9, 2015 15:31
An: gamsworld@googlegroups.com
Betreff: RE: connect a pre-existing .xlsx file to a .xlsx file generated by GMAS
Hi Renger,
Yes, sure.
the GAMS code produces an output file “results.xlsx” (all results are displayed in the first sheet).
I copy these results onto another xlsx file that I created myself, where I perform some elaborations “results_2013_2.xlsx”. Although the two files are connected through a formula, the second file does not display the figure, but it displays a series of zeros.
I attach the GAMS code and the self-made xlsx file.
Thanks,
Amanda
From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: connect a pre-existing .xlsx file to a .xlsx file generated by GMAS
Date: Fri, 9 Jan 2015 14:06:14 +0000
Hi Amanda
By sending us more information than this… (see the guidelines)
Renger
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Amanda S
Sent: Freitag, 9. Januar 2015 14:51
To: gamsworld@googlegroups.com
Subject: connect a pre-existing .xlsx file to a .xlsx file generated by GMAS
Hi,
I generate an output .xlsx file out of my GAMS model.
I have another .xlsx file (external to the model) that I connect to the output file through some formulas (=output.xlsx!$D$2, ext…).
The problem is that the second excel file does not read the results contained in the output file. So I get all zero values instead of the results of the model…
Why? how do i solve this?
Best,
Amanda
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.