Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Microsoft Office (Excel, Word) forum -... - www.officefrustration.com | Site profile

Site profile page for http://www.officefrustration.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.officefrustration.com. This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.officefrustration.com is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: Microsoft Office (Excel, Word) forum - OfficeFrustration - http://www.officefrustration.com Microsoft Office (Excel, Word) forum - OfficeFrustration
Url: http://www.officefrustration.com
Users activity: 3 posts per thread
site activity: 3,005 active threads during last week
Site rank: 340 (go to rank page)
Domain info for: officefrustration.com
 

Posting activity table on Microsoft Office (Excel, Word) forum - OfficeFrustration:

  Week Month 3 Months
Threads: 3,005 14,394 44,762
Post: 7,531 36,994 119,636
 

Authority Badge:

Microsoft Office (Excel, Word) forum - OfficeFrustration | Forum Authority Badge

Microsoft Office (Excel, Word) forum - OfficeFrustration posting activity graph:

Posts by:  day  week  month 
 

http://www.officefrustration.com Alexa graph:

Top authors on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:

Name
Posts
Diane Poremsky [MVP]
242
user's latest post:
Selected fields to update
Published (2009-11-19 22:58:00)
See http://www.slipstick.com/Contacts/dupes.asp for a list of available tools. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: Poll: What version of Outlook do you use? http://forums.slipstick.com/showthread.php?t=27072 "BorisS" wrote in message ... I...
Jacob Skaria
228
user's latest post:
modified vlookup help
Published (2009-11-19 18:59:00)
=LOOKUP(2931.15,A:A,C:C) OR with the number in D1 =LOOKUP(D1,A:A,C:C) If this post helps click Yes --------------- Jacob Skaria "tjb" wrote: There are three columns of data: A1:2930.92 A2:2954.54 A3:125 If the user enters a number (or the number is derived from another formula) that falls between the value in A1 and the value in A2, I want it to return the value from A3. "Jacob Skaria" wrote: You havnt told...
Roady [MVP]
170
user's latest post:
Windows 2002 How to put email...
Published (2009-11-19 16:02:00)
Change your message format to HTML or Plain Text; Tools- Options- tab Message Format -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "PC" wrote in message ... I have Windows 2002 and lost my settings. I don't want my attachments in the body...
Brian Tillman [MVP - Outlook]
169
user's latest post:
outlook and windows7
Published (2009-11-19 23:26:00)
"Alvaro" wrote in message ... My outlook will not start. Wow! That's descriptive. Not! -- Brian Tillman [MVP-Outlook]
Suzanne S. Barnhill
155
user's latest post:
Word 2003
Published (2009-11-19 20:55:00)
I'm guessing your Publisher document was saved as a picture. If this is the case, you don't need to change the margins at all. When you insert a picture in Word, it will be inserted In Line With Text by default and will be constrained by the page margins. Unless you change all the margins to 0" (and Word will holler if you do that), you won't be able to expand it to a full page. What you should do instead is change the...
T. Valko
125
user's latest post:
modified vlookup help
Published (2009-11-19 18:53:00)
See if this helps... A1 = some number like 55 Lookup table in the range E1:G4 ...E.....F.....G ...0....25....21 26...50.....35 51...75.....40 76............52 =VLOOKUP(A1,E1:G4,3) Result = 40. 55 falls within the range 51 - 75 and returns the result from column G. -- Biff Microsoft Excel MVP "tjb" wrote in message ... I don't know if this will be a vlookup or something similar but here's what I need: -user enters a...
Gord Dibben
115
user's latest post:
formatting of row depending on...
Published (2009-11-19 19:47:00)
First of all, you can't have more than one date in a cell unless you enter them as text. Are you saying A1 will have a varying date? Do you want to format the various dates a different color? If so, you make a rule for each Date. If you want to format various dates to same color you could use the OR function....
Dave Peterson
113
user's latest post:
Excel starts very slowly
Published (2009-11-19 23:40:00)
Just a guess... Close excel Windows start button|Run Type %temp% and hit enter Delete all the temporary files that you see there. You may have to view the details and stay away from the ones with today's date (they could be in use by other programs). Then back to excel to test it. THIBUS Trévis wrote: Hi Everybody. On a Windows XP computer with Office XP, I have this problem since a couple of days. When I launch Excel, it starts SOOOOOO...
David Biddulph
104
user's latest post:
Formula/calculation returning a...
Published (2009-11-19 19:11:00)
If your suspect value is in A2, look at =ISTEXT(A2) and =ISNUMBER(A2) -- David Biddulph "Jenny Beech" wrote in message ... I checked the calculation mode and it is automatic. How do I know if the values are real numbers? "Gary''s Student" wrote: Sounds like your values are not "real" numbers. They may be Text values. Another possibility is you may be in manual calculation mode....
Stefan Blom[_3_]
98
user's latest post:
How do I turn off keyboard...
Published (2009-11-19 15:32:00)
As far as I know, there is no way to "globally" turn off keyboard shortcuts in Word. What you can do is remove the specific shortcuts that you don't want. For that purpose, use the Customize Keyboard dialog box (Office button | Word Options, Customize: Click the Customize button). However, instead of changing the keyboard shortcuts, I would recommend making use of Undo whenever you make a mistake. For example, if you...
 

Top 10 active forums on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:

General Discussion - 1,336 new posts General Discussion - forum profile
Worksheet Functions - 1,185 new posts Worksheet Functions - forum profile
General Discussion - 1,090 new posts General Discussion - forum profile
General Discussion - 851 new posts General Discussion - forum profile
General Discussion - 824 new posts General Discussion - forum profile
Running & Setting Up Queries - 488 new posts Running & Setting Up Queries - forum profile
General Discussions - 473 new posts General Discussions - forum profile
Using Forms - 452 new posts Using Forms - forum profile
Powerpoint - 427 new posts Powerpoint - forum profile
Setting Up & Running Reports - 261 new posts Setting Up & Running Reports - forum profile
 

Top 10 forums on Microsoft Office (Excel, Word) forum - OfficeFrustration:

General Discussion - 67,677 posts General Discussion - forum profile
General Discussion - 56,734 posts General Discussion - forum profile
Worksheet Functions - 54,236 posts Worksheet Functions - forum profile
General Discussion - 52,182 posts General Discussion - forum profile
General Discussion - 48,488 posts General Discussion - forum profile
Running & Setting Up Queries - 29,171 posts Running & Setting Up Queries - forum profile
Powerpoint - 25,792 posts Powerpoint - forum profile
General Discussions - 25,263 posts General Discussions - forum profile
Using Forms - 25,242 posts Using Forms - forum profile
Setting Up & Running Reports - 18,159 posts Setting Up & Running Reports - forum profile

Latest active threads on Microsoft Office (Excel, Word) forum - OfficeFrustration:

Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 18 hours, 21 minutes ago (2009-11-20 14:37:00)  by Gary in AZ[_2_]
I use this effect a lot and you can do it by using animation alone. Paste the picture full size on the slide. Use custom animation and select Exit and pick Faded Zoom. Now select the same picture and go to Motion Paths and select Line. Draw a line to the upper right-hand corner of the slide. (You may have to adjust the line after you watch it play so it will land in the right spot) ...
Forum:  Powerpoint Powerpoint - forum profile
Thread:  Show this thread (3 posts) Thread info: New to powerpoint 2007. How to use macros to move picture. Size: 2,382 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: New to powerpoint 2007. How to use macros to move picture. :: Powerpoint :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 17 hours, 59 minutes ago (2009-11-20 14:59:00)  by Bernie Deitrick
Freshman, You can loop through the shapes looking for the text: this version will only show the fill of the shape with the matching text, Private Sub Worksheet_Change(ByVal target As Range) Dim sh As Shape If target.Address "$A$1" Then Exit Sub For Each sh In ActiveSheet.Shapes If sh.TextFrame.Characters.Text = target.Value Then With sh .Fill.Visible = ...
Forum:  Worksheet Functions Worksheet Functions - forum profile
Thread:  Show this thread (2 posts) Thread info: Conditional formatting on autoshapes Size: 2,602 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Conditional formatting on autoshapes :: Worksheet Functions :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 18 hours ago (2009-11-20 14:58:00)  by Mary Sauer[_3_]
Download the evaluation edition of Snagit. It is a super program. Who knows, you may like it so well that you will buy it. www.techsmith.comn If you have Vista there is the Snipping tool in the Accessories menu. It works really well. -- Mary Sauer http://msauer.mvps.org/ "Janetw30" wrote in message ... I need to printscreen the dialogue boxes when they appear, so that ...
Forum:  Publisher Publisher - forum profile
Thread:  Show this thread (2 posts) Thread info: Why can't I printscreen in Publisher 2003? Size: 747 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why can't I printscreen in Publisher 2003? :: Publisher :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 18 hours, 2 minutes ago (2009-11-20 14:56:00)  by Squeaky
If your steps are the same and always the same you could use the macro recorder, then attach the macro to an icon for quick access. The macro recorder icon is on the bottom left of the excel window pane. Squeaky "MeowSayTongue" wrote: Hello. I download a spreadsheet workbook often online that is a DVD database. I need to correct its structure and bring it into 2k7 ...
Forum:  Worksheet Functions Worksheet Functions - forum profile
Thread:  Show this thread (2 posts) Thread info: need to automate a sheet re-organization Size: 1,994 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: need to automate a sheet re-organization :: Worksheet Functions :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 21 hours, 23 minutes ago (2009-11-20 11:35:00)  by TAJ Simmons[_2_]
Asad It's powerpoint 'anti-alias / smoothing' the image. see MUSHY/BLURRY GRAPHICS in PowerPoint http://www.pptfaq.com/FAQ00065.htm cheers TAJ Simmons PowerPoint Master http://www.awesomebackgrounds.com awesome - powerpoint templates, powerpoint backgrounds, free samples, ppt tutorials... "Asad" wrote in message ... If I copy a picture and resize it in ...
Forum:  Powerpoint Powerpoint - forum profile
Thread:  Show this thread (4 posts) Thread info: How can I reduce a picture blur? Size: 839 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How can I reduce a picture blur? :: Powerpoint :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 19 hours, 47 minutes ago (2009-11-20 13:11:00)  by MS-Exl-Learner
Assume that you are having value in A Column Like this.. A Column ABC DEF 5646 ZYX 65466 Try this formula in B1 cell for finding the Text Values from A1:A5. =COUNTA(A1:A5)-COUNT(A1:A5) =COUNTA(A1:A5) will count the Total number cells which is having any value from A1:A5 =COUNT(A1:A5) will count the Total number of cells which is having the Numeric Values from A1:A5 But...
Forum:  Worksheet Functions Worksheet Functions - forum profile
Thread:  Show this thread (4 posts) Thread info: count - but exclude counting cells with a formula Size: 1,324 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: count - but exclude counting cells with a formula :: Worksheet Functions :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 2 days, 13 hours ago (2009-11-18 19:50:00)  by Al Campagna[_2_]
Pascoe, Well, it's a bit unusual for a report to be passing data back to a form's dataset... which probably would be the source for the report's recordset... but... While the for is still open... use the OnFormat event of the report section that contains the control value to be passed. Example: Form = frmMainForm Form text control name = ReportValue Report section = Report...
Forum:  Using Forms Using Forms - forum profile
Thread:  Show this thread (4 posts) Thread info: Pass a Report Value to a Form? Size: 2,094 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Pass a Report Value to a Form? :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 18 hours, 17 minutes ago (2009-11-20 14:41:00)  by Tom van Stiphout[_2_]
On Thu, 19 Nov 2009 08:25:31 -0800, "John Ruff" wrote: Is your database in a Trusted Location? Check the help file on this topic. -Tom. Microsoft Access MVP The inventory db was initially created in Access 2003 and when debugging, everything worked as expected. Code stopped at stop commands, code stopped at a line of code that caused an error if error trapping was ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (2 posts) Thread info: Debugging does not work - Access 2007 Size: 917 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Debugging does not work - Access 2007 :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 16 hours ago (2009-11-19 16:11:00)  by ARTURO external usenet poster
I am getting ready to create a runtime version of a program created for my employer. I created it using 2003 but will convert it to 2007 and use the runtime components for that process. 2003 had the Data Access Pages and I know that 2007 does not. We do have a web site and I would like to publish reports from Access 2007 to the web so our participants can view these. What would be ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (3 posts) Thread info: Publishing 2007 Reports To The Web Size: 592 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Publishing 2007 Reports To The Web :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 18 hours, 22 minutes ago (2009-11-20 14:36:00)  by JoAnn Paules
What happens when you try? Please be specific as you can so we can help. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Janetw30" wrote in message ... I am trying to do a little training manual for a community group who want to use border art in Publisher. I wan to print the whole page and dialogue boxes when they ...
Forum:  Publisher Publisher - forum profile
Thread:  Show this thread (2 posts) Thread info: Why can't I printscreen in publisher 2003? Size: 690 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why can't I printscreen in publisher 2003? :: Publisher :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
 

Hot threads for last week on Microsoft Office (Excel, Word) forum - OfficeFrustration:

General Discussion
Started 5 days, 14 hours ago (2009-11-15 18:21:00)  by Peter T. Daniels
Do you want to change the size of all your existing documents, or do you want _new_ documents to be set to 16 pt? For the latter, open your normal.dot or normal.dotm or normal.dotx template (which version of Word?), not by double-clicking it, but from within Word, and Modify (which version of Word?) the Normal style to change its font size. On Nov 15, 11:29*am, JE wrote: My word ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (56 posts) Thread info: Can we customize font size so at Doc. open its a different size? Size: 681 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Can we customize font size so at Doc. open its a different size? :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Database Design
Started 1 week, 3 days ago (2009-11-11 08:14:00)  by deb
dammit now i've been told i have to have peak, offpeak and total for the meter readings for each meter how do i do this without creating a separate tbl for each meter? -- deb "deb" wrote: i have to create a table that will import meter readings my first instinct is to just have a simple table that has meter number, location and then readings by date (june, july etc) ...
Forum:  Database Design Database Design - forum profile
Thread:  Show this thread (44 posts) Thread info: how to handle meter readings Size: 789 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: how to handle meter readings :: Database Design :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 5 days, 3 hours ago (2009-11-16 05:53:00)  by Jeanette Cunningham
Hi Scott, Here is a way to do it. In the form's load or open event put a line of code like this-- Me.[NameOfCombo] = Me.[NameOfCombo].ItemData(0) The code sets the combo to show the first row from the list. If the first row of the combo is not the one that matches what the form shows, you can add an extra line-- Call Me.[NameOfCombo]_AfterUpdate Replace NameOfCombo of your combo...
Forum:  Using Forms Using Forms - forum profile
Thread:  Show this thread (31 post) Thread info: Using a Combo Box to Find Records Size: 1,391 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Using a Combo Box to Find Records :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Worksheet Functions
Started 4 days, 14 hours ago (2009-11-16 18:33:00)  by Bernard Liengme
=IF(OR(ISNA(VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE)), VLOOKUP(A4,Sat!$A$16:$J$377,9,FALSE=0,"",VLOOKUP( A 4,Sat!$A$16:$J$377,9,FALSE)) best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Steve" wrote in message ... This formula works if the data is present, however, I'm getting #N/A if the lookup cell (A4) doesn't exist, which it may not on ...
Forum:  Worksheet Functions Worksheet Functions - forum profile
Thread:  Show this thread (27 posts) Thread info: If (Vlookup 0) working, but what if Vlookup cell does not exist Size: 968 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: If (Vlookup 0) working, but what if Vlookup cell does not exist :: Worksheet Functions :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
New Users
Started 5 days, 8 hours ago (2009-11-16 00:09:00)  by Bert Coules external usenet poster
I'm currently working on a document (text only, one font throughout) that has been scanned (by someone else) from a printed book. I'm seeing a curiously anomaly with regard to line spacing. I marked the entire document and set spacing to 1.5, but some double-return paragraph spaces are still spaced singly. If I mark the text where this happens and look at Format/Paragraph, the ...
Forum:  New Users New Users - forum profile
Thread:  Show this thread (26 posts) Thread info: Line spacing and other anomalies in scanned text Size: 1,144 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Line spacing and other anomalies in scanned text :: New Users :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
RE: Simple Formula - 24 new posts
Started 1 week ago (2009-11-13 14:28:00)  by Mike H
Hi, Try this with the file extension changed as required =IF(A1="Brent",[Book2.xlsx]Sheet1!$A$1,"") Mike "Canon" wrote: Excel 2009 I am looking for a formula that will do the following; If cell A1 in workbook one = Brent, then cell B1 must equal the amount in cell A1 of workbook two
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (24 posts) Thread info: Simple Formula Size: 532 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Simple Formula :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
New Users
Started 6 days, 19 hours ago (2009-11-14 13:01:00)  by Douglas J. Steele[_3_]
Fortunately, we don't have to treat you like an absolute beginner, because Sal Ricciardi walks you through this at http://office.microsoft.com/en-ca/ac...CH063650361 033 g -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Nikkinovice" wrote in message ... I know there is probably a simple answer to this, but am self taught on ...
Forum:  New Users New Users - forum profile
Thread:  Show this thread (20 posts) Thread info: Combo Boxes - linking of Size: 1,830 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Combo Boxes - linking of :: New Users :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
Started 6 days, 13 hours ago (2009-11-14 19:03:00)  by petersk
Actually, this is happening before even my field {TOC \o "1-2" \h \z \u} as well. WHAT is the deal? It's REALLY messing up formatting! "petersk" wrote: Is there any way to eliminate the extra paragraph mark being inserted in MS Word 2003 before and after the field {INCLUDETEXT} ? Kurt
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (19 posts) Thread info: INCLUDETEXT field adding extra carriage return before and after Size: 481 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: INCLUDETEXT field adding extra carriage return before and after :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Database Design
Started 1 week, 1 day ago (2009-11-12 17:45:00)  by .:RoKsTaR:. external usenet poster
Hi There, I have no experience with access, so please let me know if this task is too big. Is it feasible for me to develop a databse for my private music students that tracks and reports on the following: Contact Info Individual and overall Attendance Individual and overall Payments Material covered in each lesson Cheers!
Forum:  Database Design Database Design - forum profile
Thread:  Show this thread (18 posts) Thread info: Design with no experience Size: 525 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Design with no experience :: Database Design :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
Started 4 days, 14 hours ago (2009-11-16 18:41:00)  by Jeff Boyce
That would depend on how you define the start of the week... One option would be to get the day-of-week number of the date (in my system/setup, Monday is day 2), then subtract one less than that from the date to get the date on the start of THAT week. Yes, you can do that in a query expression. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (17 posts) Thread info: Get Start date of Week number and Year Size: 1,533 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Get Start date of Week number and Year :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."