R
Ryan
Hello,
We are having a problem with one of our excel templates at work, and we are
on a tight deadline.
The workbook is quite large....probably 50 to 80 sheets or so. Most of these
sheets have been duplicated off of other sheets.
The issue is that we have a bunch of valuation multiples linked to an
assumptions page, and when we change the number on the assumptions page, the
multiples do not update through out the template.
We have tried a number of things. We have verified that the cells are set to
automatic update in the options menu. We have also tried to go into a
worksheet select all and hit F9, which you would think would update the cells.
I have also, click on the specific that i want to update and hit F9, and
nothing happens.
The only way I can get the cell to update is if i put my cursor inside the
cell, and hit enter. There is no way that I can go through every individual
cell and update them manually like this. Plus we would not be too confident
in the integrity of our template.
I would consider myself a fairly advance user of excel, and I am quite
familiar with using macros in visual basic. If anyone has an easy solution or
a set of code that I can run that will update the template for me that would
be much appreciated.
Thanks in advance!!
Ryan
We are having a problem with one of our excel templates at work, and we are
on a tight deadline.
The workbook is quite large....probably 50 to 80 sheets or so. Most of these
sheets have been duplicated off of other sheets.
The issue is that we have a bunch of valuation multiples linked to an
assumptions page, and when we change the number on the assumptions page, the
multiples do not update through out the template.
We have tried a number of things. We have verified that the cells are set to
automatic update in the options menu. We have also tried to go into a
worksheet select all and hit F9, which you would think would update the cells.
I have also, click on the specific that i want to update and hit F9, and
nothing happens.
The only way I can get the cell to update is if i put my cursor inside the
cell, and hit enter. There is no way that I can go through every individual
cell and update them manually like this. Plus we would not be too confident
in the integrity of our template.
I would consider myself a fairly advance user of excel, and I am quite
familiar with using macros in visual basic. If anyone has an easy solution or
a set of code that I can run that will update the template for me that would
be much appreciated.
Thanks in advance!!
Ryan