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.
...how to improve shared mailbox access from branch office
Our organization has consolidated all mailboxes to centralize location. A
team of shared services specialist who often work on the shared mailbox
encounter performance issues when trying to access the shared mailbox due to
the shared mailbox are being accessed over the WAN in online mode. The shared
mailbox is attached as a secondary mailbox to their personal mailbox.
Personal mailbox does not have this issue due to all are configure to use
Exchange cache mode.
We have proposed to user Terminal server nearer to the centralize location
and Outlook Web Access but the team...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...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" <email@example.com> 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 ...Two profiles sharing one email account/pst?
I have a laptop, Win XP Pro & Office XP, that I use at work logging in as
user/domain. At home I log in as user/laptop. The first time I used it at
home & tried to check mail (mail was originally set up at work), it went
through the motions to set up a new email account. Surely, I can share the
same mail account or pst between profiles, but how?
find the pst from work on your computer - if windows explorer, tools,
options, view hidden files and folders is not set to show hidden files and
folders, change it and then browse to C:\Documents and
Settings\work_username\Local Setti...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...Outlook 2003 Address Book Sharing
I am running an SBS 2003. All my clients have Outlook 2003
What I am looking to do is have one of our managers secretary be able
to use her bosses contacts folder as an e-mail address book.
What I have tried so far:
Tried from more than one account.
Given owner access to both the mailbox and all subfolders(including
contacts) from the manager to the secretary.
I have opened the manager's mailbox as a secondary mailbox on the
I can access easily the manager's contact list from the secretaries
computer, but when right clicking -> Proper...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....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...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...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 ...how to format and print labels from an excel file
I have an excel list of people with 12 cells of information. I want to
format and print "name tags" (labels?) using only the information in four
cells. How can I do this?
You can print labels in Excel but formatting can be a problem.
Best to use Word for the mailmerge operation and select the 4 labels to print
during the setup in Word.
For help on Word mail merge using Excel as the data source.
And a t...Comments in Excel #2
When you create a comment the font and size defaults
to "Tahoma", "8". Is there a way of changing the default
font and size for comments so that when you create
comments after changing the default they will all be the
font and size that you set as the default.
eg. "Arial", "10".
You can change the default font size:
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
or use a macro to insert a comment with specific f...CHECK BOX CONTROL USING EXCEL 2000
I am working on a worksheet that has over 2300 rows. I
would like to have one field on each row to contain a true
or false value. I'd like to have a check box being
referenced to each cell. I'd like to be able to copy the
control and have it maintain a relative cell value in the
link cell property. Right now when I copy the control to
the other 2,300 rows, the link cell is a4 and every
control uses the same value at a4. Cell a4 is the only
cell that changes values when any check box is clicked.
How do I conect the check box control to a
specific/different cell without ma...Excel deleting xml item problem
I have an excel macro (in an add-in) that is called by the main excel macro
that is deleting various items in an xml file
When it gets to the last line as below it generates the following message
“An unhandled error occurred: Object variable or with block not set”
the variable is dimensioned see Dim statement that I have copied here. This
has worked for some time with no problem but suddenly out of the blue
generates this error. I have tried replacing the xml file with a copy, also
tried replacing the add-in with a copy (in case either have been corrupted).
The error desc...Marketing list dinamic export
I created a contacts marketing list for a campaign but when I try to export
in a dynamic excel sheet the sheet contains all my contacts not only the ones
in the Marketing list meaning al the contacts table. I do not think this is
correct, has anybody encountered this problem?
Yes. This is a known issue. Support has a hotfix to correct it. Also, you
can do an Advanced Find query to query all contacts from that Marketing List
and then export from the Advanced Find results screen and this problem does
"Claudio S" wrote:
> I created a contact...Export to Excel question
I have a project where I must export my OUTLOOK 2002 data
to EXCEL regularly for manipulation in EXCEL.
When the OUTLOOK data is exported, all of the OUTLOOK
fields are included.
However, I only need a few fields (name, address, phone
number). So I have to do a lot of deleting of EXCEL
columns that I do not need, after each export.
I would like to create a template of some kind that would
have Outlook only export the few fields I need, instead of
all of the OUTLOOK data. Is this possible, and if so, how?
...Open .jpg/picture file from link in excel
I am having issues opening a .jpg from a link that I have created in
excel. Instead of opening the file in the default program
(Irfanview), it opens it in IE7. When I find the file locally on my
HD, it opens with the default viewer, but when I click the link I have
made in excel (in a cell), it opens in IE7.
"Dano" <firstname.lastname@example.org> wrote in message
>I am having issues opening a .jpg from a link that I have created in
> excel. Instead of opening the file in the default program
Hi, I just found this "feature" at Excel formulas today.
Please, have a look at: http://danielgudang.multiply.com/journal/item/192
(in portuguese, but images show all)
Let me explain:
some cell C1 = sum (C2:C5)
some cell D1 = sum (D2:D5)
some cell E1 = sum (E2:E5)
A1 = C1 - D1 - E1
B1 = C1 - (D1 + E1)
A1 = B1 ??? Oh, not always!
Sometimes A1 will be +0, sometimes -0.
It's a feature of any application that uses IEEE double precision
floating point math (e.g., every commercial spreadsheet I know of).
It's the result of having finite precision ...How do I convert Excel 2007 Spreadsheet to Access 2007 database?
I used to be able to conver earlier versions of Excel spreadsheets to MS
Access. How do you do this with Excel 2007 & Access 2007?
Excel has never been automatically convertible. Import the Excel spreadsheet
as an Access table then create new, empty tables in Access and import the
data into them as needed.
Arvin Meyer, MCP, MVP
"DaveG" <DaveG@discussions.microsoft.com> wrote in message
>I used to be able to conver earlier vers...