Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Word question.
Name: Ted. Date: February 7, 2007 at 12:58:30 Pacific OS: XP Home CPU/Ram: Intel Celeron 2.66 ghz /
Comment:
I have an MS Word spreadsheet set up to automatically update totals as I type them and I would like to automatically add the totals from each monthly spreadsheet.
For example Cell D2 on 01.January plus Cell D2 on 02.February etc.
I have opened my January spreadsheet and on a blank cell have typed: =SUM(D2+"C:\Documents and Settings\Ted\My Documents\Home\Cash Book\2007\02.February D2") but I only get the 01.January total displayed. I have tried different combinations of this formula, without success. What am I doing wrong?
Name: Jennifer SUMN Date: February 8, 2007 at 06:24:10 Pacific
Reply:
Assuming you're using Excel and not word, if you want to link to another cell in another workbook, you need to put the entire filename into the formula. So, I assume that should be 02.February.xls.
Formula should read:
=SUM(D2+[02.February.xls]Sheet1!$D$2)
Assuming the value you want is on Sheet1 of of the spreadsheet and that both workbooks are in the same folder.
Life's more painless for the brainless.
0
Response Number 2
Name: Ted. Date: February 8, 2007 at 14:17:51 Pacific
Reply:
Hi, Jennifer SUMN
Many thanks for your reply. The file extensions on my files are xlr not xls and I have only one sheet per month all stored in the same folder. I have tried different combinations of the formula you posted, but keep getting the Error message. Would you mind posting an amended formula to suit. Thanks again for your help.
0
Response Number 3
Name: Jennifer SUMN Date: February 9, 2007 at 05:22:08 Pacific
Reply:
Perhaps you're using Microsoft Works (which uses xlr files) and not Excel (which is part of Office)?
I'm sorry, but I don't know anything about Microsoft Works. Hopefully, someone else here does and can assist.
Life is more painless for those who are brainless.
0
Response Number 4
Name: Ted. Date: February 9, 2007 at 15:03:17 Pacific
Reply:
I am using Microsoft Works, but thanks for your help, anyway.
Ted.
0
Response Number 5
Name: reginahtml Date: April 6, 2007 at 19:05:17 Pacific
Summary: When I copy and paste a document that I created in a notepad to MS word some of the words have green or red wavy lines under them. I think it has something to do with spelling and grammer but I am not...
Summary: Hello All, My question has to do with MS Word (2003 specificly). Due to the nature of my business I have to create NUMEROUS (about 150)different formats (under STYLING AND FORMATTING). Is there some ...
Summary: I am trying to use an if then else to print out a year whose value is dependent on the if condition. Specifically, if the current month is greater than July, I want to print out the current year plu...
0 
