No refresh in target cell when using worksheet.cells.formula = ...
 

Hi,

I have made some references to other cells in other worksheets in my excel
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.

No refresh in target cell when using worksheet.cells.formula = ...
 

Ensure that calculation is set to Automatic.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Auke" wrote:

Hi,

I have made some references to other cells in other worksheets in my excel
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.

No refresh in target cell when using worksheet.cells.formula =
 

it is! That's what is confusing

"galimi" schreef:

Ensure that calculation is set to Automatic.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Auke" wrote:

Hi,

I have made some references to other cells in other worksheets in my excel
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.

No refresh in target cell when using worksheet.cells.formula =
 

Has the procedure been run, and did it put the forumlas where you expected
them to be?

"Auke" wrote:

it is! That's what is confusing

"galimi" schreef:

Ensure that calculation is set to Automatic.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Auke" wrote:

Hi,

I have made some references to other cells in other worksheets in my excel
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.

No refresh in target cell when using worksheet.cells.formula =
 

Yes, Charlie, they did all the things right, you can also see the formula in
the formula bar, but it doesn't update.

cheers

"Charlie" schreef:

Has the procedure been run, and did it put the forumlas where you expected
them to be?

"Auke" wrote:

it is! That's what is confusing

"galimi" schreef:

Ensure that calculation is set to Automatic.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Auke" wrote:

Hi,

I have made some references to other cells in other worksheets in my excel
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.