Replies

Thank you Phil for your message. I have now done what you suggest & hopefully (!) I will not have the problem again. At least if I do I will know how to deal with it.

Stuart,

Thank you for the pointer. I hope to make good use of your assistance.

Stuart,

Thank you for the pointer. I hope to make good use of your assistance.

I found this thread through the Search facility. I have a similar problem.

As I understand it I have to go through the process for every document that has all or part of its text marked “Do not check spelling or grammar”. As I frequently create a new document from a previous one, inherited from my predecessor, is there a way of batch removing “Do not check spelling or grammar” from my document files?

John,

It’s hard to teach an old dog new tricks! First of all I did misunderstand & secondly I didn’t read your message thoroughly.

Thank you for taking the trouble & the time for a demonstration. All is now clear & I am very grateful for your help.

John,

It’s hard to teach an old dog new tricks! First of all I did misunderstand & secondly I didn’t read your message thoroughly.

Thank you for taking the trouble & the time for a demonstration. All is now clear & I am very grateful for your help.

Thanks John for your response – it is very much appreciated.

When I entered your formula in I54 Excel told me there was circular reference so I have modified your formula as follows:

=(F54/(1+C54/100)-SUMPRODUCT(D38:D50,E38:E50))/(1+C36/100)/E36

and indeed that shows& confirms the contents of D34.

However what I need to do is by some way change (play with) different values for the Adjusted Rental (in F54) & be able to see what change there is in D34 for any change in the value of F54.

To recap: At present any change in D34 is reflected in F54. I want to keep the same layout but have the facility to also see what effect a change in F54 has on D34. I hope I am not overlooking the obvious!

Thanks John for your response – it is very much appreciated.

When I entered your formula in I54 Excel told me there was circular reference so I have modified your formula as follows:

=(F54/(1+C54/100)-SUMPRODUCT(D38:D50,E38:E50))/(1+C36/100)/E36

and indeed that shows& confirms the contents of D34.

However what I need to do is by some way change (play with) different values for the Adjusted Rental (in F54) & be able to see what change there is in D34 for any change in the value of F54.

To recap: At present any change in D34 is reflected in F54. I want to keep the same layout but have the facility to also see what effect a change in F54 has on D34. I hope I am not overlooking the obvious!

Yes indeed the number of weeks in N2 does update. I added Jerry’s formula for N16 to your attachment so getting everything I needed for now. Thank you for following that up.

Yes indeed the number of weeks in N2 does update. I added Jerry’s formula for N16 to your attachment so getting everything I needed for now. Thank you for following that up.

With Jerry’s contribution in cell N16 it does exactly what I want. Many thanks for your assistance. It is very much appreciated.

With Jerry’s contribution in cell N16 it does exactly what I want. Many thanks for your assistance. It is very much appreciated.

Jerry, Thank you for your assistance. Your `cheat’ appears to work for N16 & should therefore work in the other cells in column N. Why is it a cheat way of doing it? Seems fair enough to me.

Jerry, Thank you for your assistance. Your `cheat’ appears to work for N16 & should therefore work in the other cells in column N. Why is it a cheat way of doing it? Seems fair enough to me.

That’s is it – I thought my explanation was adequate. Seems not – it is a luxury to be understood! {8;-))