Office:mac v.X #2
Operating System: Mac OS X 10.5 (Leopard)
I have subject version of Office. I know that there must be updates to this so I can bring this up to date but I can seem to find the ones I need to start the process. Can someone get me to the beginning? Thanks!!!
You can get the Office X 10.1.9 update here:
On 3/30/08 3:09 PM, in article firstname.lastname@example.orgR9absDaxw,
"AWOLGolfer@officeformac.com" <AWOLGolfer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
&g...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...Automatic Calculation #2
Why is automatic calculation keeps running even though there is no
modification done in my spreadsheet?
What makes you think that excel is recalculating?
If it's because you see Calculate in the statusbar, it could be...
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
"Lucie Ch�nier" wrote:
> Why is automatic calculation keeps running even though there is no
> modification done in my spreadsheet?
> Lucie Ch�nier
Dave Peterso...make column lists for select query.
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
I think you may want some dependent lists.
> table1 col1_1
> table1 col1_2
>...Installing office 2000 disk 2 with publisher on upgraded windows x
I can not get disk 2 to install. It preloads then as files start to copy, it stalls then ends with error message. this is office2000 professional 2 cd set.
everything else works exept publisher and its components.
What is the error message?
MVP Microsoft [Publisher]
"cugolfn" <email@example.com> wrote in message
>I can not get disk 2 to install. It preloads then as files start to copy,
>it stalls then ends with error message. this is office2000 profess...Exchange 2007 Evaluation version #2
Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <firstname.lastname@example.org> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message
news:%23xtVdlR8FHA.740@TK2MSFTNG...Merge Cells #5
I know how to merge two cells using formula =A1&B1, but can someone tell me
how to insert spacing between the two within the new cell. I'm merging a
part number and description, and need spacing between them.
the " " is showing that you want to insert text, and that the text is a
space character. It could be "-" or ".", etc.
"R. Stevens" <R. Stevens@discussions.microsoft.com> wrote in message
> I know how to merge two cells using formula =...Why do I get four postcards to the same person when I mail merge?
I merged my Excel document with my Publisher document just now and did a
print preview, but the 4-up view shows that all 4 are heading to the same
How do I tell Publisher that each "up" is a different address?
If you are using 2003, this is a bug. If you are unsure there is a test print on
the print dialogue screen. Use plain paper for the test.
If you are using 2007, be certain you select multiple pages per sheet.
"Batmantis275" <Batmantis275@discussions.microsoft.com> wrote in message
news:324C9E10-38C9-4DA0-89C...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Chart
Subject: Chart - Title Widths
Date: Tuesday, February 03, 2004 12:43 PM
Chart - Title Widths
Does anyone know how to find the width of a title/axis title?
...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
...Upgrading from Exchange 2000 Standard to Enterprise Cal ? #2
I know the upgrade process from exchange 2000 standard to enterprise
seems pretty straight forward. However, I have a cal question. Are my
standard cals still good with this upgrade. Say I have right now
standard 2000 with 30 cals. If I upgrade to Exchange 2000 Enterprise
with 25 cals to pass the 16mb limitation.
Would I then only have the 25 cals or 55 total cals?
...Keeping rows together after link
I have spreadsheet that has several columns that link to anothe
spreadsheet.This is G1:P100. My A,B,C,D columns is where I pu
information related to the information in G-P. For instance, G-P link
to a students information. It changes all the time. In A-D I hav
columns to input criteria for each student. The problem is that whe
the link updates the criteria and the student info end up on diffren
rows now. For instance If B1 is " Has Housing" and G1 is " Steve" afte
the update " Steve" might move to G3 and the "Has Housing" does no
move with it
Message...Outlook 2003 Contact data
Just starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <email@example.com> wrote:
> When composing an e...copying data
Getting errors when copying data from workbook to workbook. Shutdown and
restart allows without errors.
...Questions regarding Data center operation
I have over 8 years of IT experience but very new to the Data Center
space and have 4 questions. If someone can answer, I would really
You can consider these questions more of a brainstorming ideas.
1. If a facilities capacity is re-classified as 5 MW lower than it was
previously, what needs to happen here?
2. We need to expand Network capacity at a facility by 2 times but for
only 20% more money, how can we do it?
3. Where to start if you are responsible for tech refresh in existing
4. During tech refresh planning you find out about a delay in delivery...How to Perform Lookup on Alphanumeric Data?
I've found a few hundred posts about VLOOKUP and HLOOKUP functions and
their limitations. But I've not found a post that addresses my
Is there a way in Excel to get a VLOOKUP to find the next highest value
in a Table where the lookup data is alphanumeric? I have a list of
names in Column A and I'm trying to perform a lookup on a table in
another spreadsheet using:
But the problem is that the lists are from different sources, so the
spacing, punctuation, and inclusion of middle names/initials varies.
The...Multipage newsletter in the body of an email
I knew that Don had a website where I could find his organization's
newsletter. I just sent him the results of that process I posted about the
other day. I'm anxiously awaiting his comments. (Just because I can send it
to myself and it looks fine doesn't mean it will to others.) :-)
MVP Microsoft [Publisher]
...Mailbox Cleanup Agent #2
We need to delete a few mailboxes on our Exchange 2003 Server.
We've deleted the AD acounts but when we go into system nanager and try
to choose purge, it's greyed out. Our retention period for deleted
mailboxes is 30 days. Can we run the cleanup agent now on the live
system to speed up the deletion of the mailboxes? Or is it not
On 3 May 2006 06:37:15 -0700, "Jim C" <firstname.lastname@example.org> wrote:
>We need to delete a few mailboxes on our Exchange 2003 Server.
>We've deleted the AD acounts but when we g...Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec
I need a way to fix a print problem. When I go into File - Page Setup, and I
choose which rows to repeat at the top ($1:$5) and select which columns to
repeat at left ($A:$A), the rows at the top never print completely on pages 2
through the end. Only on the first page can I see the entire title and
subtitle. On the remaining pages they get cut off where Column B would
begin. Can I fix this?
Select only the rows to repeat at the top, and see if that solves your problem
email@example.com_2nd_at. Randburg, Gauteng, South Africa
> ...IStorage/IStream #2
I am working on an application that has more than a dozen of data files.
When the application closes, it uses IStorage/IStream to move them into one
file (IStorage), from the user's point of view. When the application is
started next time, these data files are extracted from the one file. By
extraction, I mean to programmatically read from IStreams and then write to
new, separate data files. The reading and writing are done chunks by
chunks. The whole process works fast only if all the data files are small.
The main issue to me is not disk memory space, but the speed. ...adding rows to formula reference
I'm using Excel 2002, what I'd like to do is have a
formula, say B4 and when I copy down instead of going to
B5 I want it to be say B11. So something like B4+7 but
not the value of B4 +7. I wasn't sure if this is
possible and I can't seem to find a definite answer.