Hi,

I have an excel workbook which has various reports created (using excel
formulae across different worksheets) based on master data which I maintain
in the first sheet.

If the master data is entered (or pasted manually) into the first sheet,
then all other formulae will get automatically reflect the formula results.

But when I try to download the master data into the first sheet via a
program (using the workbook as a template), the rest of the sheets do not
reflect the results of the formulae (though I have set autopopulate on Open).
It expects me to go back to each cell and click enter to start viewing the
data.

Does anyone have an idea how to resolve this? Do I need to use a macro?

Try this little trick to force formulas back to formulas.

Select all cells and Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 02:58:01 -0700, RN <(E-Mail Removed)> wrote:

>Hi,
>
>I have an excel workbook which has various reports created (using excel
>formulae across different worksheets) based on master data which I maintain
>in the first sheet.
>
>If the master data is entered (or pasted manually) into the first sheet,
>then all other formulae will get automatically reflect the formula results.
>
>But when I try to download the master data into the first sheet via a
>program (using the workbook as a template), the rest of the sheets do not
>reflect the results of the formulae (though I have set autopopulate on Open).
>It expects me to go back to each cell and click enter to start viewing the
>data.
>
>Does anyone have an idea how to resolve this? Do I need to use a macro?

Thanks. This works. But is there any trick/way to automate this?



"Gord Dibben" wrote:

> Try this little trick to force formulas back to formulas.
>
> Select all cells and Edit>Replace
>
> What: =
>
> With: =
>
> Replace all.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 21 Jun 2007 02:58:01 -0700, RN <(E-Mail Removed)> wrote:
>
> >Hi,
> >
> >I have an excel workbook which has various reports created (using excel
> >formulae across different worksheets) based on master data which I maintain
> >in the first sheet.
> >
> >If the master data is entered (or pasted manually) into the first sheet,
> >then all other formulae will get automatically reflect the formula results.
> >
> >But when I try to download the master data into the first sheet via a
> >program (using the workbook as a template), the rest of the sheets do not
> >reflect the results of the formulae (though I have set autopopulate on Open).
> >It expects me to go back to each cell and click enter to start viewing the
> >data.
> >
> >Does anyone have an idea how to resolve this? Do I need to use a macro?
>
>

Record a macro when you do it manually.

Then rerun that macro whenever you need it.

RN wrote:
>
> Thanks. This works. But is there any trick/way to automate this?
>
> "Gord Dibben" wrote:
>
> > Try this little trick to force formulas back to formulas.
> >
> > Select all cells and Edit>Replace
> >
> > What: =
> >
> > With: =
> >
> > Replace all.
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Thu, 21 Jun 2007 02:58:01 -0700, RN <(E-Mail Removed)> wrote:
> >
> > >Hi,
> > >
> > >I have an excel workbook which has various reports created (using excel
> > >formulae across different worksheets) based on master data which I maintain
> > >in the first sheet.
> > >
> > >If the master data is entered (or pasted manually) into the first sheet,
> > >then all other formulae will get automatically reflect the formula results.
> > >
> > >But when I try to download the master data into the first sheet via a
> > >program (using the workbook as a template), the rest of the sheets do not
> > >reflect the results of the formulae (though I have set autopopulate on Open).
> > >It expects me to go back to each cell and click enter to start viewing the
> > >data.
> > >
> > >Does anyone have an idea how to resolve this? Do I need to use a macro?
> >
> >

--

Dave Peterson