Using viewer with Office 2007, formula problem

[GracePanda]

Hi all. Even though I have Office 2007, I have not worked with it much at all. I will be helping my brother with his business spreadsheets. He uses a Mac but saves it as excel to email it. (or something like that) I downloaded an excel viewer to be able to see the spreadsheets from his more recent program.

He walked me through the formulas to change the pricing to sub-contractors. That bit worked. Next, we tried to total up the entire column of pricing. He gave me the sum total formula, I typed it in and got: #VALUE! I got the same thing on multiple attempts.

Any ideas? I hope that I have been clear enough for you to understand our problem.

We are in 2 different states, that why I don't just use his Mac.

[FDibbins]

Hi and welvcome to the forum

I used a viewer ages ago, and if you are only using a viewer on the workbook, you probably can do just that - view the file, not change it.

[GracePanda]

I was able to change the entire column of prices. I just had problems when I tried to add it all up.

[dredwolf]

Try opening it in the office version of Excel instead, it may be that the viewer does not support the auto-sum features of excel...just a thought

[FDibbins]

OK so maybe the viewer doesnt support formulas and functions - try dred's suggestion maybe?

[GracePanda]

I tried to open it from Office, but it couldn't even see them in my download folder. To get to the spreadsheets, I just click on them in their specific folder.

Anyway, the problem has been resolved. When telling me the formula, he told me "sum=" instead of "=sum". But, thanks for your suggestions!

[dredwolf]

Yes, that would do it...lol
Glad you got it resolved !