|
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:
|
0
|
0
|
0
|
|
Post:
|
0
|
0
|
0
|
|
|
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:
How do I set up a randomly...
Published (2009-11-07 16:33:00)
what can I say... notes hired all the rocket scientists first. http://www.websetters.co.uk/WSAddIns/WSRAII/index.htm has an addin that can do it. -- 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: "JGT" wrote in message ... Lotus Notes has a function...
user's latest post:
I restore a mail box and I want...
Published (2009-11-07 15:56:00)
Depends on the source and what exactly you backed up. General backup and restore instruction can be found here; http://www.howto-outlook.com/howto/backupandrestore.htm -- 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 ----- "Ahmed Nabil Abdel-Latif"...
user's latest post:
MIN from another worksheet
Published (2009-11-07 18:46:00)
Ofcourse with the sheet references.... (array entered) =MIN(IF((Sheet1!G1:G100="condo"),Sheet1!F1:F100)) 'error handled version..incase you have any error cells in the range F1:F100 (array entered) =MIN(IF((Sheet1!G1:G100="condo")* (ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Hi Shelina Try the below array...
user's latest post:
Word 2007 templates
Published (2009-11-07 20:03:00)
Put it in the Trusted Templates folder, which should be a place on your Places Bar or a link in your Favorites pane. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "charles arnett" wrote in message ... Help I have converted a template to word 2007 template. it works. What folder do I put it in or how do I get there? charles arnett
user's latest post:
Conditional sum wizard
Published (2009-11-07 23:42:00)
mark -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... =SUMPRODUCT(--A1:A100=Sheet2!$E$2),--(B1:B100=Sheet2!F4),C1:C100) Ooops! I left out an opening parenthesis: =SUMPRODUCT(--(A1:A100=Sheet2!$E$2),--(B1:B100=Sheet2!F4),C1:C100) -- Biff Microsoft Excel MVP "T. Valko" wrote: You didn't provide enough specific detail. Try something like this:...
user's latest post:
One command in one cell...
Published (2009-11-07 18:19:00)
Formulas in a cell cannot change values in any other cell unless the other cell has a formula referencing the first cell. Q6, Z6 and E7 must have their own formulas referencing F2 value. i.e. In Q6 =IF(F2=B5,N6,"not equal") Gord Dibben MS Excel MVP On Sat, 7 Nov 2009 08:42:01 -0800, Chas52 wrote: I would like to create a cell that directs a number of cells formulas. eg. If I direct F2=B5, then Q6 will equal N4, Z6 will equal...
user's latest post:
eMail Reply Changes Default Address
Published (2009-11-07 20:04:00)
"htglaser" wrote in message ... Running MS Outlook 2007, with 2 eMail addresses set up. When sending a message from default eMail, Outlook automatically sends the message "from" the address specified in the default account. However, when responding to received eMails (no matter where from), by selecting the "reply" command, Outlook never reverts to the default account as the address that...
user's latest post:
Still struggling with DCount
Published (2009-11-07 23:01:00)
On Sat, 7 Nov 2009 13:29:01 -0800, scottyboyb wrote: I put the = sign in and now I ger a #error. DCount seems to have me on the ropes. I have rechecked the spelling of each field and query and everything seems fine. I mayjsut give up and not provide this info on the form. Iti is the reports, but I was hoping to have it on the forms where pople are working. Post the SQL of the query. Is AmountPledged in fact in the query? If you open the query...
user's latest post:
Want to keep...
Published (2009-11-07 18:08:00)
Change the formulas to values in the cells/worksheets where you don't want the formulas to update. Select the range to fix Edit|copy edit|paste special|values Is one way of doing it. raisingcain wrote: I use Excel 2002. I have a workbook where I enter data throughout the year in one of the worksheets. There are 52 other worksheets, representing each week of the year (with a beginning date and end date for each week.) Based on formulas...
user's latest post:
Create update query for...
Published (2009-11-06 01:48:00)
I was trying to add the 1 in the query until it equals the 20 and then stop. What field in table 2 is it being add to? How about posting the SQL of your query. -- Build a little, test a little. "accesshacker" wrote: The query I have been working on is populating the 1. No fields are being reduced to zero. Table #1 is only a holder for what is remaining. I am testing right now and only using one Item from one PO#. There are a...
|
|
|
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
- 65,734 posts
|
General Discussion
- 55,262 posts
|
Worksheet Functions
- 52,617 posts
|
General Discussion
- 50,942 posts
|
General Discussion
- 47,257 posts
|
Running & Setting Up Queries
- 28,477 posts
|
Powerpoint
- 25,216 posts
|
Using Forms
- 24,643 posts
|
General Discussions
- 24,590 posts
|
Setting Up & Running Reports
- 17,824 posts
|
|
|
|
|
Latest active threads on Microsoft Office (Excel, Word) forum - OfficeFrustration:
Started 2 days, 9 hours ago (2009-11-06 23:01:00)
by Mary Sauer[_3_]
I suspect the font is a matter of taste. I was sent a Catholic service booklet
for Lent, it was all done in Arial 10 pt. Eight points seems small, hopefully
your parishioners are young with excellent eye sight and your church is well
lighted.
--
Mary Sauer
http://msauer.mvps.org/
"Art" wrote in message
...
I am preparing a Catholic Mass booklet on an A4 side folded page to...
Started 1 day, 15 hours ago (2009-11-07 17:43:00)
by Gordon[_13_]
"vtwoods" wrote in message
...
Upgraded from Windows XP to Windows y. Did all proper backups per MS
instruction. Old contacts list and all emails are there, but no address
book
. Area for selecting conacts for address book remains gray in
contacts/properties/addressbook no matter what I do.
Please help as my contact list is long.
VTWOODS
Ps. I can add new ...
Started 4 days, 8 hours ago (2009-11-05 00:16:00)
by John W. Vinson
On Wed, 4 Nov 2009 12:52:02 -0800, an wrote:
Hi!
I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles
I have:
Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub
When I click one checkbox all Val textboxes turn to ...
Started 11 hours, 48 minutes ago (2009-11-08 20:57:00)
by Stefan Blom[_3_]
Use the Options dialog box (how to open it depends on your version of Word).
Note that if you do know how to change the settings but it doesn't seem to
work, take a look at http://www.gmayor.com/Character_Units.htm .
--
Stefan Blom
Microsoft Word MVP
"whang9" wrote in message
...
Started 4 days, 10 hours ago (2009-11-04 22:13:00)
by Bob I
The trial version of Office 2007 is the latest "viewer".
Ronald wrote:
How to browse through Word and Excel documents folder?
When there is a document folder, is there any application to view documents
like in a slideshow, changing to next document with mouse click?
Mainly Office 2002 and 2003 Excel and Word.
I did some googling but couldn't find anything functional.
There ...
Started 2 days, 4 hours ago (2009-11-07 03:55:00)
by Diane Poremsky [MVP]
Are you using POP3 to connect or the Outlook Connector? The connector
should delete them from the account online.
--
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:
"Al" wrote in message
news
|
|
Hot threads for last week on Microsoft Office (Excel, Word) forum - OfficeFrustration:
Started 1 week, 1 day ago (2009-11-01 06:50:00)
by Guy Lydig
Is your text direction set to: right-to-left?
" Peter T. Daniels" wrote:
I'm typing a page of Arabic. Is there any way to get the line numbers
to appear in the right margin (i.e., at the beginnings of the lines)?
Setting "mirror margins" doesn't do it.
.
Started 4 days, 10 hours ago (2009-11-04 22:13:00)
by Bob I
The trial version of Office 2007 is the latest "viewer".
Ronald wrote:
How to browse through Word and Excel documents folder?
When there is a document folder, is there any application to view documents
like in a slideshow, changing to next document with mouse click?
Mainly Office 2002 and 2003 Excel and Word.
I did some googling but couldn't find anything functional.
There ...
Started 1 week, 1 day ago (2009-11-01 02:54:00)
by saraqpost@yahoo.com[_2_]
Set rst = "SELECT tblActData.Dept, tblActData.Amount,
tblActData.COAKey, tlkpCOA.Number, " _
& " tlkpCOA.Account, tblActData.Subsidiary,
tblActData.FiscalYr, " _
& " tblActData.FiscalMonth, " _
& " #" & "DateSerial([tblActData.FiscalYr],
[tblActData.FiscalMonth],1) # " _
& " FROM tblActData INNER JOIN tlkpCOA ON tblActData.COAKey =
tlkpCOA.COAKey " _...
Started 6 days, 8 hours ago (2009-11-03 00:34:00)
by Gina Whipp
plisvb,
I can think of two options...
Option 1.
Have an Invoice Detail table that stores that calculated value.
Option 2.
Have the Invoice sent to a . pdf file and now it is forever immortalized.
http://www.lebans.com/reporttopdf.htm
I have actually used both and sometimes together. Yes, you will read that
storing calculated fields is a big no-no BUT there are exceptions and ...
Started 6 days, 18 hours ago (2009-11-02 14:15:00)
by Suzanne S. Barnhill external usenet poster
Yes and no. The spacing will always be displayed in points but may be
entered in inches or centimeters, which Word will convert to points. Select
the default "0 pt" in the Spacing Before/After box and type in "3 cm" (Word
will convert to 85.05 pt.)
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"Terry Hollands" wrote in...
Started 5 days, 11 hours ago (2009-11-03 20:49:00)
by Rudolf Lamour
"Zen" r- schrieb im Newsbeitrag
...
Hey all,
I'm experiencing a frustrating problem with access on 2 out of 4
computers, literally all of a sudden. Here's the scoop.
4 office computers with XP Pro and Office 2002. We just made a change to
our front end mdb so we could push some invoices to quickbooks.
I went ahead and opened the front end on two computers, everything
...
Started 5 days, 5 hours ago (2009-11-04 02:47:00)
by Pete_UK
It doesn't look as if any cells in column C contain 0 (or does your -
indicate 0 ? If so, then there are 4 of those).
Generally you would have a formula like this:
=SUMPRODUCT((B2:B10=3)*(C2:C10=0))
if you want both conditions to be satisfied at the same time before
you count that row, or this:
=SUMPRODUCT((B2:B10=3)+(C2:C10=0))
if you want either of the conditions to be ...
Started 1 week ago (2009-11-02 04:34:00)
by Kritz external usenet poster
My text is all set to Garamond, but when I insert a cross-reference (in this
case, to figures and titles) the cross-reference text insists on coming up in
Times (which is the default Normal font). I'm not willing to keep switching
back and forth between Times and Garamond by redefining Normal, I just want
cross-references to come up in the font into which they're being inserted.
Any ...
Started 1 week, 3 days ago (2009-10-30 06:43:00)
by Graham Mayor
I wasn't aware that you could 'create' symbols using the Character Map?
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
alchemist wrote:
I created symbol/character using Character Map but when I copy/paste
it into the MW document it gives me completely different symbol (some
kind of hieroglyph). What can I do...
Started 6 days, 9 hours ago (2009-11-02 23:32:00)
by Dirk Goldgar
"RCGUA" wrote in message
...
I have an Access 2003 Form with a listbox on it. The row source is a
Table/Query. The query sorts the records according a Date/Time field
in the table. The Date/Timefield is Short Date.
When I use the form and add a record to the list box, the code below
scrolls down the listbox to bottom and selects the last record. The
problem is that the last...
|
|
Size: 1,115 bytes
