Formatting of Excel OLEs in Word is messed up after updating links
I have a Word document with multiple Excel objects pasted and linked to their
source files. Every time I try to update any of them, they revert to their
original size they had when I first pasted them in, instead of the formatting
I applied afterward.
I've tried to fix this by editing the links, but the "Preserve formatting
after update" box is greyed out on all of them.
Is there another way to force these objects NOT to revert to original size
every time I update? The way it is now sort of defeats the whole purpose of
linking them in the first place.
...Can't Install Money 2006 SB on Vista
I'm trying to install Money 2006 Small Business on my new Vista Computer and
it keeps crashing during the install process. I had it on another computer
and upgraded to Vista and it ran just fine. Any Ideas?
In microsoft.public.money, srazook wrote:
>I'm trying to install Money 2006 Small Business on my new Vista Computer and
>it keeps crashing during the install process. I had it on another computer
>and upgraded to Vista and it ran just fine. Any Ideas?
For Money 2006 make sure this Vista update in installed:
Be sure that you...Unable to restore Money file in MM 2006
Greetings once again all...
Recently I have had to restore my computer and am now not able to use the
money file I previously backed up, no matter what I try. It either asks me
for a password or when I do manage to open the money file by clicking
File>Open and browsing for the backed up money file, it constantly asks me
for my password and when I enter it it tells me that it's wrong even though
I am signed in with it in Windows Messenger. And when I do manage to get
beyonde the sign in screen it does not display any of my accounts.
Could anyone please help?
Elaine...Junk "Microsoft" emails - Possible Partial Solution
Like a lot of people on these forums, I've been bombarded with virused /
junk email from "Microsoft" , "MS" etc.
I can telnet to my www provider and use Pine set up a rule to delete all
emails where the sender is "Microsoft", and this would help a lot.
The problem is the "Deleting" is not the same in Pine as "Expunging", so, in
the end, my Outlook winds up downloading the Deleted messages. The tech
support there does not have an answer for this one.
Is there a way in Pine to set up a rule to "Expunge" rather than "Delete&...in excel how can we put formula to convert numericalfigureto word
for example :
in excel i have mention 25000.00 in numerical amount , i want to know how
can i convert in next colum , about word ?/;
How can i put formula to make the numerical in to words like 25000 in
numerical to twenty five thousands in word.
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> for example :
> in excel i hav...MS money 2004 Deluxe canadian edition
Is there a money 2004 deluxe canadian version? I have
found the Standard edition everywhere, but not the Deluxe.
I am using the trial version and it will expire soon, but
when I try to buy the Canadian version, MS Money keeps
taking me to US only version purchase options. The MS
Money web site couldn't have been less helpful.
In microsoft.public.money, Derrick wrote:
>Is there a money 2004 deluxe canadian version? I have
>found the Standard edition everywhere, but not the Deluxe.
>I am using the trial version and it will expire soon, but
>...How do I set up a formula in excel that is the tenth root of 7 ve.
How do I set up a formula in excel that is the tenth root of 7 versus the
square root of 7?
try the formula =7^(1/10).
"kestig1" <firstname.lastname@example.org> wrote in message
> How do I set up a formula in excel that is the tenth root of 7 versus the
> square root of 7?
...Creating a Microsoft Words document from an existing Excel spreads
I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under these 6 fields are some
records of my customers.
COMPANY NM DATE ITEM1 ITEM2 ITEM3 QUOTATION
---------------- ------- -------- ------- --------
ABC Limited 3 Apr xxxxx xxxxx ...Incorrect Office Updates in Microsoft Update
I recently did clean installs of XP and Win7 on 2 different PCs. Each PC
was loaded with Office 2007. When I ran Microsoft Update after the Office
installs, it shows I needed Office 2007 SP1, not SP2. I manually downloaded
and installed Office 2007 SP2 and then checked Windows Updates for any
needed patches. It still showed I needed Office 2007 SP1...even though I
just installed SP2.
Does anyone know how to 1) have Office SP2 show up as a needed update
instead of SP1, and 2) how to configure Windows Update to show that no SP is
needed after SP2 is installed?
th...excel 2002 crashes
When i try to add a control to a from in Excel VBA using the
function OLEObjects.Add, Excel 2002 crashes.
Well, i have found the solution to the problem which is that before
adding the control I set the EnableEvents property to false. Then
everything works fine.
The reason for my post is that, this same problem does not happen in
Excel 2000, it happens only in Excel 2002..
Any idea why this is so ?
Thanks & Regards,
...Formulas in Excel using [R-1] not A10 references
I converted a Word document into Excel 2003 and when creating formulas,they
are formatted as the cell the formula is in plus or minus a number of rows or
columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these
formulas in the regular format referencing Row and Column number i.e. =Sum
Tools >Options, the General tab, uncheck R1C1 reference style
> I converted a Word document into Excel 2003 and when creating formulas,they
> are formatted as the cell the formula is in plus or minus a number of rows or
> columns. An example...Web upgraded money recover
I downloaded the 60 day trial of Money 2004 6 months ago.
I then used the web upgrade to get the full license. My
hard drive crashed this week. I have backups of all my
money files. My problem is, how can I get a replacement
of my web upgrade? I already paid once, is there someone
I can call at MS to get a replacement license key, or do
I have to purchase it again?
Search postings for newsgroup microsoft.public.money using an advanced
search at http://groups.google.com. You will find your answer there.
And next year, please just go buy the CD like us other folk.
"Ian" <ia...MS Money for Palm OS
Is Money 2002 available for the Palm OS?
Any resources/links would be appreciated
Any version of Money? 2002?
"Mick" <email@example.com> wrote in message
> I have looked into various Palm OS finacial softwares.
> None would sync both ways, either with Quicken or Money
> except for one. It's called Ultrasoft and can be found at
> It syncs with Money (not Quicken) and allows me to input
> data either into Money or Ultrasoft on my Pa...Problem inserting delta symbol into Excel
Hello. I recently posted a question related to the issue of
putting a mu (=B5) symbol into MS Excel charts. Someone kindly
suggested using the Alt-numeric code (alt-0181) to place this symbol
into the spreadsheet cell which then showed up nicely in the chart.
However, when I try to do this same operation using alt+ NumPad 68
(susposed to give the delta symbol), all I get is a capital D. What
gives? Why does one symbol work and not the other? I even
downloaded the program QuickKeys from SourceForge.net and this still
did not solve the problem. Any ideas??
Thank you....Money 2001 suddenly started crashing
I've used Money 2001 for several years. Suddenly it started crashing
when I go to Investing/Portfolio. This may have started after I
installed SP2 for Win XP. Anyone have the same problem or know of a
Do you get an error message?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or http://www.microsoft.com/uk/support/money/feedback especially
if it's a UK specifi...excel fillin color
Fill-in color does not show on worksheet while working on the sheet only in
the preview Have I turned off a switch or what needs to be done?
The high contrast setting may be turned on. There's information in the
following MSKB article:
OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed
"ron" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Fill-in color does not show on worksheet while working on the sheet
> the pr...money 2004 won't sync
After re installing both money pc and desktop I can't get money to sync
anymore. lost all files on the pocket pc.
please help? Activesync doesn't let me use the money settings it's grayed
out all other programs sync fine.
Have you tried to repair the money file on the desktop?
>After re installing both money pc and desktop I can't
get money to sync
>anymore. lost all files on the pocket pc.
>please help? Activesync doesn't let me use the money
settings it's grayed
>out all other programs sync fine.
>--...convert text in excel to uppercase
Is it possible to convert all text in a workbook or on a spreadsheet to all
In VBA Editor
Dim MySht As Worksheet, MyCell As Range
For Each MySht In ThisWorkbook.Sheets
For Each MyCell In MySht.UsedRange.Cells
MyCell = UCase(MyCell)
> Is it possible to convert all text in a workbook or on a spreadsheet to all
"elaine" <email@example.com> s...Save as Excel from Master Project
I am trying to export from a master project with about 8 sub-
projects. When I try and export from the master to excel, it does not
include certain text fields. Why? Any work arounds? I need the text
field (name) to use the excel sheet.
How are you exporting?
Data lives in the sub-projects, not the master. However, try expanding all
sub-projects and try again
Not all custom fields roll up to the sub-project tasks, so their data is not
available in the master.
For this and other reasons (including no risk of file corruption) I usually
create new masters every week but no...Excel link update question
I need to maintain an excel workbook which contains a lot of links to
workbooks. Since the linked workbooks change every week, I need to
the links accordingly. For example, a cell with formula
!A10" will be changed into "='[sep_4.xls]sheet1'!A10". I tried to do
Find/Replace. However, the link is updated every time it is changed.
The link updating takes a couple of seconds. So it may take a hour
to finsh it for a workbook with thousands of links. Could anyone tell
to shut down the link updating when...Using backup as import
Can I import a Money 2002 backup file into Money 2007?
No but you should be able to restore it.
"perple" <firstname.lastname@example.org> wrote in message
> Can I import a Money 2002 backup file into Money 2007?
...What exactly is office, excel, and encarta?
Office is a collection of programs including Excel, Word,
Outlook, PowerPoint, and Access. Excel is a spreadsheet program
that is included in the Office collection. Encarta is an
encyclopedia, dictionary, and thesaurus.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Samantha" <Samantha@discussions.microsoft.com> wrote in message
How can I tell Excel NOT to round up when it calculates?
Click Tools menu,
Choose Calculation tab
Check "Precision as Displayed"
> How can I tell Excel NOT to round up when it calculates?
Excel does *not* round up, unless you tell it to so in the formula, like
with the ROUNDUP() function.
It may seem that it rounds (not UP, just plain round); because no more
digits fit in the column width or because you told Excel (via Formatting)
not display more than a certain number of digits.
"In the background" there is still an ...Import Templates for Dynamics CRM 3.0
I am trying to use the standard import file into Leads, and it is
coming up with data type not valid, length not valid however I am 100%
sure it is correct.
Have any of you out there got formatted xls files that have the
correct data types. field lengths that we could possibly use as a
template to see if it is actually my error?
...what is the name of a sub form download from microsoft website
i need to add a sub form to a form created in access. i tried to start the
the feature is not currently installed. i try to install but it is looking
for a disk for me to insert. i do not have a disk to insert. can i go to
microsoft website and download the sub form feature for access? if yes, what
is the name of the download.
Are you sure it is not installed? Open your main form in design view. Click
the Toolbox button in the menu at the top. There are two buttons at the top
of the Toolbox, an Arrow and a wand. Is the Wand highlighted. If not, click
on it then click on th...