Exporting to excel - formatting issue

[cc100]

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!

[EViews Gareth]

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

[cc100]

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

[EViews Gareth]

Pasting the link as Text will probably do it.

[cc100]

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!

[EViews Gareth]

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

[cc100]

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

Thanks.

[EViews Gareth]

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.

[cc100]

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?

[cc100]

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

[EViews Gareth]

Use paste special