Re: st: Export Excel and Cell references

[Jeph Herrin <stata@spandrel.net>]

Do you have AutoCalculation enabled in the workbook? Where you check 
this differs on the version of Excel, but in Excel 2010 it is under 
Formulas-> Calculation options.

Tangentially, you may be interested in using -putexcel- to write your 
table directly instead.

hth,
Jeph


On 12/23/2013 11:12 AM, Tal Elmatad wrote:
> Hello,
>
> I am having a problem with Export Excel in Stata 12. I generally
> create a “raw data” worksheet and then create a second formatted
> worksheet that references cells on the “raw data” worksheet. I noticed
> that when I rerun my Stata script, if I use Export Excel the cell
> references don’t update (i.e. while the raw data is updated, the
> formatted worksheet is showing the old values). I suspect that since
> Excel only updates references when a connected cell is updated, that
> the Export function is somehow not registering as a change to Excel.
> Is there an option I can use to force the workbook to update? Thank
> you!
>
> Tal Elmatad
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/