|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for Microsoft Office (Excel, Word) forum - OfficeFrustration (http://www.officefrustration.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Microsoft Office (Excel, Word) forum - OfficeFrustration posting activity graph:
|
|
http://www.officefrustration.com Alexa graph:
|
Top authors on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:
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...
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...
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]
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...
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...
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....
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...
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....
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:
|
|
Top 10 forums on Microsoft Office (Excel, Word) forum - OfficeFrustration:
General Discussion
- 67,677 posts
|
General Discussion
- 56,734 posts
|
Worksheet Functions
- 54,236 posts
|
General Discussion
- 52,182 posts
|
General Discussion
- 48,488 posts
|
Running & Setting Up Queries
- 29,171 posts
|
Powerpoint
- 25,792 posts
|
General Discussions
- 25,263 posts
|
Using Forms
- 25,242 posts
|
Setting Up & Running Reports
- 18,159 posts
|
|
|
|
|
Latest active threads on 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)
...
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 = ...
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 ...
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 ...
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 ...
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...
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...
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 ...
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 ...
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 ...
|
|
Hot threads for last week on Microsoft Office (Excel, Word) forum - OfficeFrustration:
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 ...
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) ...
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...
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 ...
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 ...
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
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
...
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
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!
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 ...
|
|
Size: 2,382 bytes
