Formula Changes when data entered in referenced range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 formulas in a worksheet that refer to a range. When data is entered
in the range, the formulas adjust to exclude the cells with data. Range
B5:B211 When data is entered in B5, range in the formulas becomes B6:B212.
The workbook has nearly 200 worksheets with the same formulas. I'm working
in Excel 2003. Does anybody have any idea what's going on?????
 
Might help if you include the formulae that you are using.

Regards

Trevor
 
I'm on an XL97 machine right now, and I can't remember exactly which
settings might be causing this.
From my XP machine at the plant, I remember something in
<Tools> <Options>
Maybe <Calculations> or maybe <Edit>,
Where you *uncheck* a setting that mentions extending formulas and formats,
or something similar to that.

If you can find what I'm talking about, it might be worth a try.

Nothing ventured, nothing gained.<g>
 
The option I think you're referring to is on Options <Edit>. It was ON, but
I don't think that is the problem. Entering data didn't affect the formulas
when Sharing was turned off. I found a work around by selecting the entire
column (B:B) in my formula, but it would be nice to find out if this is a bug
of some kind? Microsoft???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart data - Range Names 1
VBA help 2
Ctrl D with formulas 3
Cell address in a range 7
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Summing cells based on mulitiple criteria over mulitple columns 1
Named range labels in formulas 1
Autofiller Tool Help 3

Back
Top