|
More site info...
Microsoft: Office | Forum profile
|
|
Forum profile page for Microsoft: Office on http://www.tek-tips.com.
This report page is the aggregated overview from a single forum: Microsoft: Office, located on the Message Board at http://www.tek-tips.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Microsoft: Office" on the Message Board at http://www.tek-tips.com is also shown in the following ways:
1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Microsoft: Office:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
72
|
270
|
808
|
|
Post:
|
212
|
782
|
2,159
|
|
|
Microsoft: Office Posting activity graph:
|
Top authors during last week:
user's latest post:
creating arrays from...
Published (2008-12-04 11:43:00)
"My original question is still not answered" What is the remaining issue? Skip, Just traded in my old subtlety... for a NUANCE!
user's latest post:
Microsoft Word Can't To...
Published (2008-12-02 16:04:00)
No, that is true. Bitmap versus Vector graphic. A concept that appears beyond scope of most. All bitmaps are specific information regarding separate and specific pixels in a grid, and are resolution dependent. Sitting there as a file, there is NO information about the relationship of pixel_A to pixel_B, even if they are beside each other. All manipulation of pixels...
user's latest post:
Microsoft Word Can't To...
Published (2008-12-01 16:34:00)
i used to use word for images purpose, because i need to create DOC and then convert it to PDF. It was necessary for executing work of costumer, he wish PDF and now i have done *.doc and converted it to PDF. I hope he is happy =)
user's latest post:
Can I refer to links...
Published (2008-12-03 09:46:00)
Yes, I am sure! Cheers, Glenn. Beauty is in the eye of the beerholder.
user's latest post:
Stop Excel 2003 files opening in...
Published (2008-12-04 03:38:00)
If I highlight several excel files in a folder, right click and select Open each opens in its own instance of Excel. (NOT just windows, separate instances). To solve this I have tried the following but ot doesn't work for me: Quote: Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows...
user's latest post:
MS Office 2007 Excel Print Issue
Published (2008-12-03 14:30:00)
If you select that row, can you print the Selection in the print dialog box? -- JP
user's latest post:
Word 2007 - Figure numbering
Published (2008-12-02 10:48:00)
Oh thanks!! I think I can get this now.. So now once that is done, how do I go about applying this to my Figure caption numbering?
user's latest post:
Name of Worksheet into cell
Published (2008-12-03 09:29:00)
"...as one would expect using ANY spreadhseet function, if the calculation mode has been set to MANUAL." That's a little over-simplistic. Even with Automatic recalculation switched on, a re-calculation is not triggered by saving, printing, or copying (at least in Excel 2003). As a result, if you enter an =cell("filename", A1) formula and then use "Save as" with a new name, the old, incorrect name will remain...
user's latest post:
Countdown Timer for Excel
Published (2008-12-03 10:05:00)
Skip, How does that act as a countdown timer. I have entered the information exactly how you show it and it does nothing.
user's latest post:
Name of Worksheet into cell
Published (2008-12-01 13:19:00)
If there are multiple Worksheets and I add the formula to a cell then all the sheets(that have the formula) will have the same name as the sheet that the formula was just added to. If I goto another sheet it also has the previous sheet name until I repaste the formula into it's cell. Now all the other sheets change to that sheets name. I was wanting to have a cell on each sheet to have it's...
|
|
|
|
Latest active threads on Microsoft: Office::
Started 2 days, 18 hours ago (2008-12-02 12:29:00)
by DragonRe
Hello, is there a way (without using VB) of making an array without a column in between? For example I want an array that is column A and column C but *not* column B. I'm using this in conjunction with vlookup. Thanks!
Started 2 weeks, 2 days ago (2008-11-18 23:26:00)
by AJD10
I know this can be done, but just not sure how to do it. Have an excel sheet with names, address and order info with names appearing as many times as there are orders. Number of orders vary, anywhere from 1-20 or more. Name1 Order1 Name1 Order2 Name1 Order3 Name2 Order1 Name3 Order1 Name3 Order2 This needs to be sorted and reformated Name1 Order1 Order2 Order3 Name2 Order1...
Started 3 days, 21 hours ago (2008-12-01 09:40:00)
by lrfcbabe
Excuse me for asking this again but I am confused on one thing. If I open an Excel spreadsheet ("Myfile.xls") it opens up using the Excel application. This is also for the most part considered a "Workbook", for me anyway being a VB(A) kinda person. In that "Workbook" there are multiple " Worksheets", the tabs that run along the bottom of the "Workbook". I used "worksheet name into cell" for ...
Started 1 day, 9 hours ago (2008-12-03 22:23:00)
by IngDep
Have a workbook with two worksheets. One worksheet has data similar to; Name----------Rank Smith, Bob----1 Jones, Jill---2 Wall, Kim-----3 The other worksheet has data similar to; Name------------Address------------Phone----Rank Stat, Sheila----111 Ave------------214009 Smith, Bob------245 City Drive-----324568 Jones, Jill-----324 Sand Drive-----153897...
Started 22 hours, 48 minutes ago (2008-12-04 08:36:00)
by Macinslaw
We are migrating 100 users from office 2002 (XP pro) to 2007. The GPO to uninstall Office XP first does not work and causes problems for the installer of 2007. So, I found an obscure little command line reference, but no instructions on how to use it and wondered if anyone here could assist me. msiexec.exe /uninstall "d:\******" /qb is supposed to be the command to uninstall office, however...
Started 1 day, 16 hours ago (2008-12-03 14:46:00)
by patriciaanne
Hi- I have a pivot table that is linked to another Excel spreadsheet in a separate file and the name of that file changes every month (only 1 sheet in the file). I have gone into Workbook Connections and removed the old workbook connection and added the new one and clicked Refresh and it gives me a warning and turns the pivot table into a static data range and the report filter drop down no ...
Started 1 day, 1 hour ago (2008-12-04 05:45:00)
by leightur
Does anyone know a cheap / free alternative to Excel/spreadsheet that will accept > 65,536 rows of data. I know new versions of Excel accept more rows of data, to be honest all I need is a cost effctive way to import > 65,536 data without the added features. Thanks in advance, Leigh
Started 1 day, 2 hours ago (2008-12-04 04:44:00)
by robcarr
hi, i am trying to get this formula to work, but it always shows 0 with array entered or not CODE =SUMPRODUCT((Agent!$C$3:$C$4000=$D$2)*(Agent!$V$3: $V$4000)*(Agent!$AS$3:$AS$4000=$I$2)) range c contains dates, D2 is the date reference, v is the range i need to sum (these are formulas that show a value in currency format), as is the a word i need to check, i2 is the reference for the word...
Started 1 day, 3 hours ago (2008-12-04 04:03:00)
by Bill4tektips
I have a Word document linked to an Access query for mailmerge purposes. My problem is that when I "Merge to new document" the dates in the letter are in U.S. format and not UK format e.g. 11/18/2008 instead of 18/11/2008. I have checked the Language settings in Word and English UK is selected, I have checked the query and it appears OK in there (correct format). Any ideas anyone?
Started 1 day, 3 hours ago (2008-12-04 03:38:00)
by Gavona
If I highlight several excel files in a folder, right click and select Open each opens in its own instance of Excel. (NOT just windows, separate instances). To solve this I have tried the following but ot doesn't work for me: Quote: Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the ...
|
|
Hot threads for last week on Microsoft: Office::
Started 5 days, 22 hours ago (2008-11-29 09:22:00)
by JamesHMorgan
Microsoft Word can't to move images with pixels accuracy, in it documents? When i try to move any pasted image in document, i very often i need to move images with pixels accuracy. For example in attached file, you can see digits (it's text), and blue circles. For example i need to move circles so, that digits was at center of circles. And when i try to move circle (image) for doing digits ...
Started 3 days, 21 hours ago (2008-12-01 09:40:00)
by lrfcbabe
Excuse me for asking this again but I am confused on one thing. If I open an Excel spreadsheet ("Myfile.xls") it opens up using the Excel application. This is also for the most part considered a "Workbook", for me anyway being a VB(A) kinda person. In that "Workbook" there are multiple " Worksheets", the tabs that run along the bottom of the "Workbook". I used "worksheet name into cell" for ...
Started 1 day, 22 hours ago (2008-12-03 08:30:00)
by GMDorsey
I am trying to place a countdown timer on multiple cells so we can track ETA times for jobs we do that we track on a spread sheet each day. Is this possible and if so how do I go about doing it.
Started 1 week, 1 day ago (2008-11-27 07:02:00)
by Ca1icoJack
I have files scattered throughout my harddrive and network. The path to them is obviously different, but the final folder and contents are labelled identically. How could I search my entire network for such folders? I tried using a wildcard to specify all locations: "\*\ & MyFolder & "\Inspect\" I want to be able to chose the variable MyFolder and copy certain files from "Inspect" into ...
Started 2 days, 21 hours ago (2008-12-02 09:46:00)
by vandelayIndustries
Hi All, When you insert a caption, and you want the Figure number to be labeled "Chapter number.Figure number" automatically (I.e. Figure 4.2), you need to have your Chapter title (Heading 1 style) as a numbered list so it knows which chapter you are in. I was wondering if there is a work-around for this so I do no have to number my chapter title and still have it automatically numbered as "...
Started 1 week, 1 day ago (2008-11-27 07:01:00)
by Nicos67
Hi All, How do I write a COUNTIF formula to produce the following results: I have active linked cells that show totals I want the countif in another location to show that if: the cells contents are over a certain number to show 1 the cells contents are under a cettain number to show 3 the cells contents are in between one and another set of numbers to show 2 Many thanks in advance Nico
Started 2 days, 20 hours ago (2008-12-02 11:23:00)
by kwilson529
I am trying to use the countif function for a column to determine how many cells are between 0-3, 4-7, 8 and above (for example) I would like to use one countif function to be able to say =countif(t2:t256, [0-3] ) for each of the number ranges but don't know how to format it. Can I just say =countif(t2:t256, > 8) for over a value of 8? I am working with Excel 2007.
Started 5 days, 16 hours ago (2008-11-29 15:22:00)
by MearMortal
I use this formula: - =COUNTIF('Games'!C1:C46,"Europe ") But the end cell number changes based upon it being the last empty cell, calculated from this formula: - =MATCH("Y",'Games'!F:F,0)-1 This formula reports the row number in column F with a Y in it and returns the value -1. Hence the last empty cell. What I want to do is substitute the value generated from the second formula with the ...
Started 1 day, 9 hours ago (2008-12-03 22:23:00)
by IngDep
Have a workbook with two worksheets. One worksheet has data similar to; Name----------Rank Smith, Bob----1 Jones, Jill---2 Wall, Kim-----3 The other worksheet has data similar to; Name------------Address------------Phone----Rank Stat, Sheila----111 Ave------------214009 Smith, Bob------245 City Drive-----324568 Jones, Jill-----324 Sand Drive-----153897...
Started 2 days, 18 hours ago (2008-12-02 12:29:00)
by DragonRe
Hello, is there a way (without using VB) of making an array without a column in between? For example I want an array that is column A and column C but *not* column B. I'm using this in conjunction with vlookup. Thanks!
|
|
Size: 303 bytes
