EViews.com

Hi Gareth,
I am running a program and then I am linking my eviews workfile results to excel using the eviews addin version 8.1 (excel version 2010). The data is always formatted as an excel table and if convert this to a standard range then I lose my links. How can I fix this?

Thanks!

Can you be more precise as to what you're doing and why it isn't working?

Hi Gareth,

I am basically copying and 'pasting as links' some matrices from my eviews workfile into an excel sheet. I am doing this so that I can just run my program every week and then refresh the excel sheet, which will pull in the new results. But when I paste in the results from eviews into excel, the matrices are formatted as tables, and if I change the formatting in excel then the link is lost. How can get the results to not be pasted in as tables?

Thanks

Pasting the link as Text will probably do it.

Hi Gareth,

Thanks for the quick reply. Excel only seems to let me paste as link or simply paste....If I just paste then obviously it is nolonger linked. Do you know whether there are some settings in excel I need to fiddle with?

Thanks!

When you paste as a link, you have to specify the type you want to paste as:

Hi Gareth, Thanks for your screenshot. Attached is mine (using the eviews Getdata addin), the options are 'import and link' or 'import'.

Thanks.

So when you said you were pasting, what you meant was that you were using the Excel Add-in (which is completely different...).

Try copy and pasting instead.

well originally i did state i was using the addin:

Hi Gareth,
I am running a program and then I am linking my eviews workfile results to excel using the eviews addin version 8.1 (excel version 2010). The data is always formatted as an excel table and if convert this to a standard range then I lose my links. How can I fix this?

And simply copy pasting does not work as it is nolonger a 'link' so it won't update when i update the program file

Use paste special