Thread: #NAME!#?
View Single Post
  #3   Report Post  
Old September 30th 05, 11:45 PM
Dave Peterson
Posts: n/a

Do you see letters in the column headings or numbers?

If you see numbers, try:
tools|options|general tab|uncheck R1C1 reference style.

Then retype the formula.

amartin-kelly wrote:

Hi I am putting in a formula =SUM(week1:week4!A8) because we named our pages
weeks. When I put in the formula it pops up saying something like #NAME!?#
telling me the name is unrecongnizable...any comments?



Dave Peterson