Office Updates #2
How can one determine what update has previously been
accomplished in any Office product?
CES <email@example.com> wrote:
> How can one determine what update has previously been
> accomplished in any Office product?
Not all files are updated at every update.
Check the version number of this file:
/Applications/Microsoft Office X/Office/Microsoft Component Plugin
It gets updated at every update...
- Mac:MS MVP (Francophone) -
(MS) MVP: http://support.microsoft.com/default.aspx?ln=FR&scid=fh;FR;mvp
Newsgroups produits MS: http://support.micros...Linking a Column List to a Row List #2
Thanks for the help, it worked perfectly
Moe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1250
View this thread: http://www.excelforum.com/showthread.php?threadid=27428
...Mail merge with Excel in Publisher 200
Whenever I open a merged document in Publisher with I merged with an Excel
spreadsheet, I must re-establish my link with the spreadsheet (including any
filters I originally set)--quite annoying.
This is has not always been the case; I have some connections which have
stayed connected. These could possibly be ones I did in an earlier version
Is this a problem with just Publisher 2000 or is there a way to permanently
connect my publisher document with my Excel spreadsheet?
...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <firstname.lastname@example.org> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Excel 2000: allow users to edit ranges
I have Excel 2002 SP3 but another user has 2000 SP3. I created a big
worksheet but only want him to be able to edit 1 column, so I used the Tools
> Protection > Allow users to edit ranges and gave him access to that 1
column. When he opens it in 2000, he can not edit anything without first
removing the protection from the entire worksheet. When I go to his Tools >
Protection, he only has 3 options: protect sheet; protect workbook; protect
and share workbook. He has no allow users to edit ranges option. Was this
option not included in Excel 2000?
Is there an update or add in f...Excel
When using auto-filtering, how can I "number" how many records are displayed.
Your question has fallen into an Access news group. Try an Excel news group
for a better chance at getting a quick answer.
Microsoft Access MVP
> When using auto-filtering, how can I "number" how many records are displayed.
"Rachel" <Rachel@discussions.microsoft.com> 在郵件
> When using auto-filtering, how can I "number" how many records are
I recently joined AGLOCO because of a friend recommended it to me.
I am now promoting it to you because I like the idea and I want you
to share in what I think will be an exciting new Internet concept.
AGLOCO's story is simple:
Do you realize how valuable you are? Advertisers, search providers
online retailers are paying billions to reach you while you surf.
much of that money are you making? NONE!
AGLOCO thinks you deserve a piece of the action.
AGLOCO collects money from those companies on behalf of its members.
(For example, Google currently pays AOL 10 cents fo...Forwarding Stationery #2
I am wondering if you can assist.
Where can I cange the look and feel of messages when you attach to an e-mail
from a thrid part programme? My 'New Message' stationery is black but when
I attach a file from another programme, it is white.
Look forward to your responses
...todays date #2
How would I get todays date in an excel spread sheet
"Kaushi" <Kaushi@discussions.microsoft.com> wrote in message
> How would I get todays date in an excel spread sheet
Better (just the date, not the time):
Both will update with every recalculation. If that is not what you require:
Microsoft MVP - Excel
"Gordon" <email@example.com> wrote in message
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Unable to Install Outlook'07/Unable 2 Uninstall Completely Outlook
I upgraded to Professional 2007 from 2003. Everything worked except for
Outlook 2007. I am unable to access any Outlook version, I tried to
uninstall Outlook 2003 but it won't completely uninstall and Outlook 2007
won't install over 2003. "The update package could not be opened..." is the
message I receive when I click on Outlook 2003 shortcut, but yet in the
control panel, Microsoft Standard Edition 2003 shows up but I cannot
uninstall or delete. How can I get Outlook 2007 to be installed.
> I upgraded to Professional...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...How to print a greet. card from Publisher on a 2-side card stock?
Publisher has a pre-set printing option for greeting cards to print on an A-4
paper. How can I change it so it sould print on a regular two-sided card
stock size 5.5"x 8.5"?
Booklet setup on letter size stock.
Mary Sauer MSFT MVP
"CLX" <CLX@discussions.microsoft.com> wrote in message
> Publisher has a pre-set printing option for greeting cards to print on an A-4
> paper. How can I change it so it sould print...Mailbox Backup 2 do or not 2 do !!
Hi I have always run Veritas to backup mailboxes but have
read lately that some people advise that it isn't
necessary to backup individual mailboxes. On smaller
customers we are using NT Backup, are we missing
individual mailbox restore abilities on smaller sites or
just wasting tape space and time on larger sites ?
> Hi I have always run Veritas to backup mailboxes but have
> read lately that some people advise that it isn't
> necessary to backup individual mailboxes. On smaller
> customers we are using N...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Recolor embeded Excel graph in PowerPoint
Is there any way to recolor an embeded Excel graph colors
to match the color scheme of targeted PowerPoint file?
You could create a user-defined custom chart type with the colour schem
of the presentation and apply it to the embedded chart.
I am not aware of any in-built color synchronization between powerpoin
and excel, though.
Message posted from http://www.ExcelForum.com
when you say "A user-defined custom chart type"
Is this "Chart>Chart type>Custom types>User-defined" ?
1. Create the same type of graph with MS Graph.
2. Add...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Excel
The project I'm working on currently uses a ASP/JScript combination to
popuate a CSV file. The file is then parsed into excel. I've written a
function that handles some of the whitespace characters (via regular
expressions) that mess up how the data is displayed in the cells. Often, the
hidden char(10) and char(13) would push the data to another row. Due to the
way that this is written right now, I'm also searching for commas and
replacing them with the ASCII version as well as some other things to handle
data formatting. Due to the way these are put into the excel document ...Excel Read Only in New Windows 7 Installation
I have upgrade to Windows 7 Professional, installed Office Home and Student
and copied my XP-created EXCEL files but now they are all Read Only. I assume
this is due to the new installtion but have no recollection of any passwords
in the XP version. Is there some file that contains this data that I can
locate to correct the Windows 7 files? Thank you, Jim Harper
perhaps those files were on a CD or DVD for the transfer? If then they
can be read-only. Simply r-click on the File name and select Properties,
and UNcheck the Read-only box. To do this for all the Files in a folder ...EDC #2
I am getting a "Connection Error" when tryging to use EDC. It is definitely
connect to the Internet but RMS thinks otherwise.
Thank you in advance for any help you may provide!
Are you on the TSYS platform?
Are you getting:
- "Connection Error = 400" OR
- "Status Failed, Approval Connection Error"
"Daniel Suh" wrote:
> I am getting a "Connection Error" when tryging to use EDC. It is definitely
> connect to the Internet but RMS thinks otherwise.
> Thank you in advance for...Automation #2
I have created five (5) grids within Excel consisting of correlations
comparing various commodities. Each correlation grid represents years
of data (i.e., 5yr, 10yr, 15yr, etc.).
Right now, I am manually checking each commodity across every grid to
see which other commodities are closely or loosely correlated. At the
same time, I check to see if these correlations are consistent across
all years of data. Once the correlation is manually validated, I type
the summary list into yet another worksheet.
Basically, here's an abbreviated example of what the grids look like:
AD BO BP C CC CD...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Looking for Excel site similar to "The Word MVP Site"
I'm looking for an Excel site similar to and as good as "The Word MVP Site"
Anyone have some suggestions?
Gary''s Student - gsnu200828
> I'm looking for an Excel site similar to and as good as "The Word MVP Site"
> Anyone have some suggestions?
> Thank...Excel and macro
I have an Excel worksheet and am wanting to make it intereactive so scores
(from a questionaire/assessment) can be entered in by the user and the
results of the assessment displayed.
What I'd like to know is how to write a formula/macro which looks at 4
scores, notes the results of # 1 and# 2 in order, and displays text based on
Is this possible in Excel ?
Many thanks in advance
I'm not sure what you're looking for, but the LARGE function can
return the nth largest number from a range. For example,
will return the largest numb...How do I copy an Excel chart to paste into InDesign?
I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
it into InDesign CS2, the labels on the lower horizontal axis do not come
along. Is there some special way to do this that I'm missing?
1. Are you pasting into a frame? If so the default setting is to crop
the graphic. You may just be cropping the bottom.
2. My experience is that axis labels in Excel sometime do not transfer
well. My solution is to leave all labels blank, along with the chart
title and use Indesign to label chart.
3. If you wish you can try and see if you can export the chart to
a jpg or ...