Microsoft Office Evolves Community as Part of Office 2010 Launch:
As you know, this is a big year for Microsoft as we are launching the latest
version of Office. Office 2010 is all about making it easy for you to get
and use Office on your terms. Office 2010 lets you work from the office,
from home, or at school across the PC, the Phone, and the Browser. You
can purchase Office 2010 from retail, from our OEM manufactures when you
purchase a new PC, or get it direct from Microsoft, faster than ever via a
new software delivery mechanism called Click-To-Run.
And, we're working ...formula help #8
The following formula queries and totals information on a specified sheet.
In this case the specified sheet name is 2003
I have several sheets (2001, 2002, 2003, 2004.....)
I would like to have the value for the sheet name in the formula reference a
cell in which I could type in the name of the sheet I want to query.
Can someone tell me how to accomplish this. Just changing the '2003' in the
formula to the reference cell doesn't work. (FYI - the reference cell will
In Sheet2, cell N2, I want to calculate the maximum value:
I’ve already been shown (by some very learned and helpful fellows on this
site - thanks) that in cell E2 of Sheet2 the SUM of these cells can be
but don’t know how to perform the MAX function in a similar manner. Or even
if this is the best way.
Furthermore, I don’t follow the relationship between the cell I’m in and the
cells I’m trying to SUM, MAX, etc, and the figures +2 and =2 (in the
example). The concept of...Upgrade to Version 8
I currently have Version 6 Internet Explorer (Update versions SP2; if that's
helpful). Can I upgrade to 8 with the free download? I tried, got through
steps 1 and 2, but then nothing. I can't get to step 3, which is the setup
> I currently have Version 6 Internet Explorer (Update versions SP2; if that's
> helpful). Can I upgrade to 8 with the free download? I tried, got through
> steps 1 and 2, but then nothing. I can't get to step 3, which is the setup
As a pr...Quattro Pro 8 - Office XP
Is there a converter to allow the use (read and write) of Quattro Pro 8
files in Excel 2002 in Windows XP? I have intalled the Quattro Pro 7
converter for Excel 2000 without much success.
AFAIK MS does not provide such a converter. Some options:
- save the file in QP 8 as Excel file
- check www.dataviz.org for a commercial converter
"Ted" <Ted@discussions.microsoft.com> schrieb im Newsbeitrag
> Is there a converter to allow the use (read and write) of Quattro
...Need to add cells from column B to create new total in column D
This must be elementary, but I am new to VBA. I have a SQL query that returns data to my sheet that is grouped by status, and ordered by date. Here is an example of what is returned:
9/27/2003 17:00 1 Open-Propose
9/27/2003 17:00 1 Open-Review
9/27/2003 17:00 31 Open
10/4/2003 17:00 2 Open-Review
10/4/2003 17:00 38 Open
10/4/2003 17:00 4 Open-Propose
I need to create a chart so that for each given date, a total of all "Open*" is presented, because for charting purposes it doesn't matter what the status is, the overall count is what is important.
I want this returned:
9/27/200...How to print PDF for 5.5 x 8 1/2 booklet to show pages 1,2,3
I want to create a PDF of a booklet to post on the web. The booklet is 8 1/2
x 11 landscape and when folded is 5.5 x 8 1/2. It is 1-20 pages. When I
create a PDF, it produces the pages, for example, printing 2 on lefthand
side and 19 on therighthand side.But, I want to print pages exactly as I
see on screen with no 2 on lefthand side and no 3 on righthand side.
After no luck experimenting with Adobe Acrobat 7.0, am I going to have to
print out the pages front/back, fold them, and then scan to get the pages to
appear as they would in the book?
Print MSPub 03 to PDF --consecutive ...Random 8 character ID number
I need to know the formula to create a column of random 8 character ID
numbers, preferably with a set prefix of 3 numbers. I'd be REALLY happy if
I could create it with random text and numerals, but it doesn't have to be.
(where 123 is the constant)
Thanks in advance for your help.
Put in A1: 1234567890abcdefghijklmnopqrstuvwxyz
and in A2:
T(RAND()*36)+1,1)&MID(A$1,INT(RAND...address QR 2123 in version 7.5 and 8.0
Our client is encountering the error that has been documented as QR 2123.
They have requested that it be fixed in GP 7.5. MBS has said that it will
not be addressed until version 9.0.
Below is the detail of the QR, followed by MBS's response and our client's
Quality Report 2123 -
Description: When a check is voided in a different month than it was
originally issued, the Payroll Summary report doesn’t reflect the void
Steps to Recreate:
1.Build, Calculate, and Post a payroll check with a check date of 3/1/2003.
2.Go to Reports | Payroll | Period End and ...=?Utf-8?Q?Purchase_Order/Receiving_=E2=80=93_Amoun?= =?Utf-8?Q?t-driven_PO=E2=80=99s_vs._Quantity?=
We have a customer who uses the Great Plains Purchase Order module for
transactions which are not inventory/quantity-driven, as an additional
accounting trail within the system. For example, they may issue a PO for a
year’s worth of a service-type expense, where they are approved for a certain
dollar amount, but they must enter a quantity which may or may not reflect
the true number of receipts that will occur against the PO (since these are
unknown, and are not as important to them as the dollar value of the PO). As
they do receiving transactions against the PO, there are times where...=?UTF-8?B?RmluYWwgUmVtaW5kZXIgLSBNaWNyb3NvZnQgUmVzcG9uZHMgdG8gdGhlIEV2b2x1dGlvbiBvZiBDb21tdW5pdHk=?=
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past several years while customers and participants are increasingly finding
solutions in the forums on Microsoft properties and third party sites. This
move will unify the customer experience, centralize content, make it easier
for active contributors to retain their influence, mitigate redund...Question on Money 2000, Version 8.1
I will describe what happened a few days ago (I have had
the above program since 2000 & have used it daily since,
with no problems):
With Money Open to "Home", click on "Accounts", click on
any one of my several investment accounts & a screen comes
up and directly under the word "View" on the left side of
the screen are the words "Account Summary". When I click
on "Account Summary", the column headings and
corresponding data do not include all the same column
headings an data that showed up before this problem AND
the column ...Demonstration version of Great Plains 8.0???
My organization is seriously considering using Great Plains 8.0 and I was
curious if anyone knows where I could find a trial version of the software to
help us make up our minds.
If you talk to a local business partner, they can set up GP with a
sample company. There aer two versions: standard and professional. The
professional runs on SQL Server. Therefore, if you wanted to get a trial
of it, you would need to supply a machine with SQL Server.
> My organization is seriously considering using Great Plains 8.0 and I was
> curious if anyone knows where I could find a tri...__dopostback only does what I want after row 8
I want my datagrid rows to be clickable, so that a button column is
fired when my user clicks anywhere on a row. Using Google, I figured out
how to do it, but it only works after row 8. From row 9 on, the next
page opens properly, but clicking rows 1 through 8 does nothing - the
dopostback fires, but the page does not change. If I remove this code,
the button column works fine. This sub seems to be disabling rows 1-8
for some reason.
Here's my sub:
Protected Sub DataGrid_ItemCreated(ByVal sender As Object, ByVal e As
e.Item.A...where can I download eConnect 8 for trial
I don't have CustomerSource account, can I download it somewhere?
I believe you will need to get it from a partner.
"ray" <firstname.lastname@example.org> wrote in message
>I don't have CustomerSource account, can I download it somewhere?
It's available in MSDN Subscription.
"ray" <email@example.com> wrote in message
> I don't have CustomerSource account, can I download it somewhere?
I woul...Printing 11" by 8.5"
How do we setup the page so it will print vertically11" by 8.5? I just want
the text wide and bigger but the defautl print setting which is 8.5 by 11 is
not big enough.
In Page Setup, try the Landscape orientation.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> How do we setup the page so it will print vertically11" by 8.5? I just want
> the text wide and bigger but the defautl print setting which is 8.5 by 11 is
> not big enough.
I have an excel file with 52,560 lines in it. Each line in the
"energy" column represents energy produced in a ten-minute period.
Over the course of a year that's 52,560 ten-minute periods.
I need to get energy produced in hourly periods. In other words, add
the entries in the "energy" column in groups of six, making a new set
of 8,760 "energy" quantities, one entry for each hour in the year.
How would I do that?
You can do it with a formula.
With data in column A, enter formula into B6 and fill down...
=IF(MOD(COUNTA($A$1:A6),6)=0,SUM(OFFSET(A6,-5,0,6,...Distribution List #8
I am trying to create a Distribution List that is for
Board members. Can you tell me the proper way to set up a
Distribution List with inside and outside email addresses?
create the DL, add your members, then give it a valid smtp address...
"Todd" <firstname.lastname@example.org> wrote in message
> I am trying to create a Distribution List that is for
> Board members. Can you tell me the proper way to set up a
> Distribution List with inside and outside email addresses?
...Saving CVS in UTF-8
Is there a way to have Excel save a sheet in UTF-8 CVS format?
For htm and xml it can be done, by tweaking with "web settings" when saving.
Agoston Bejo shared this with us in microsoft.public.excel:
> Is there a way to have Excel save a sheet in UTF-8 CVS format?
> For htm and xml it can be done, by tweaking with "web settings" when
Do you mean:
CVS - Concurrent Versioning System
CSV - Comma Separated Values
Amedee Van Gasse using XanaNews 18.104.22.168
If it has an "X" in the name, it must be Linux?
How To ...Error accessing SQL data in Great Plains 8.0
Just upgraded to Great plains 8.0 (from 7.0) running on MS Small Business
Server 2000 with SQL 2000.
We can VIEW posted Sales Orders (Inquiry > Sales > Transactions by Customer)
but they will not print properly. They look fine on screen (all data is
there), but when we try to PRINT them, none of the information is there
(customer name & address, items on invoice, prices, etc). All we get is a
blank invoice and the detailed and descriptive error message “Error accessing
SQL data” (how helpful is THAT?!).
Same behavior regardless of workstation or user login (including “sa”)....Internet Explorer 8 Loads Twice
Whin I open IE8 in XP it loads twice.
If I close one in Task Manager, it closes both.
Anybody else experiencing the same thing?
"TMEBOY" <TMEBOY@discussions.microsoft.com> wrote in message news:92D8ABB9-F033-4C7E-B60A-16F92A2140C9@microsoft.com...
> Whin I open IE8 in XP it loads twice.
> If I close one in Task Manager, it closes both.
> Anybody else experiencing the same thing?
> Any solution?
If you mean by "loads twice" you see two iexplore.exe tasks in
Task Manager's Processes tab, yes, that is normal.
Hint: try a s...=?utf-8?B?5rex5Zyz5p+Q55S15L+h6K6+5aSH5YWs5Y+46K+a6IGY?=
...Windows 7, explorer 8 change from 64 to 32 bit to allow flash play
Can anyone help, all I am getting are messages that state adobe flash player
is not compatable with 64 bit change your browser to 32 bit. I go to the
exporer site and it tells me I already have explorer 8 downloaded and when i
check the available downloads none are for Windows 7.
I've checked programme files and unlike explorer 7 there is not a 32 & 64
Internet Explorer 8 should have come with Windows 7 (supposedly
preinstalled). If it is preinstalled, check the following location for the
C:\Program Files (x86)\Internet Explorer\iexplore.e...Outlook 2000 error #8
When I open Outllok 2000, I get a pop up to give in my pw
for backup.pst, When I click cancel, I can use it without
problems. I tried to create as well a new back-up of my
mail, but keeps asking first for my pw of backup.pst
How to proceed easily to create a new back-up of my mails?
...Upgrading to 8.0
We are planning on upgrading from 6.0 to 8.0 We have
four issues that we need some help on. (We are not using
1. How do you deplete inventory from one site?
2. How do you expense the transfer of raw material
inventory to the end user departments department?
3. How do other customers handle a raw material and
finished good inventory using Great Plains?
4. If we have three inventory classes, can we lock out
certain users from accessing items different inventory
1. How do you deplete inventory -- Do you mean you want to get all the On