Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formulae not working in specific workbook

Status
Not open for further replies.

Durkin

Programmer
Nov 6, 2000
304
GB
Formulae are not working in a specific workbook I have. Presumably, this is some option I have turned off by mistake. Any help would be appreciated. Durkin
 
Actually, after messing around with it a bit more, it's weirder. If I copy a column from the workbook in question to another sheet, formulae work fine. But if I then insert a column to the right of this column, formulae don't work in the inserted column but do in all the other columns. And even if I just paste one cell into another sheet and then insert a column to the right, only the cell to the right won't take a formula. Very confusing.X-) Durkin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top