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 EditReplace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 02:58:01 -0700, RN 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 EditReplace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 02:58:01 -0700, RN 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 EditReplace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 02:58:01 -0700, RN 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