How can I stop data labels reverting to a default position
I change the alignment of my data labels and save my chart. When I reopen the
workbbok my data labels revert to their origional position.How do I stop this
...Help: copy old ss data to new ss, with row mis-alignment
Daily I create a spreadsheet from a database, In column "A" are "Item
Numbers" in random order. I insert a 'new' column in front of column
'A', where I type text comments as I receive verbal updates during the
The next day, I generate a new spreadsheet from the database whose
"Item Numbers" may OR, may not have been on yesterdays spreadsheet.
Currently, my routine is to copy-n-paste yesterdays comments into this
new version which is a pain and time consuming.
Can someone provide the formula, that if there is a match ...Add BCC to emails
Hi, I'm running Outlook 2002 SP3 and need to add the BCC option to my
mails. I had assumed that this would have been done via the View
option, but I can't find it - anyone any suggestions as to how I do
it? It will need to be permanent i.e. the option to be able to send
bcc to be on every email I write
(Reply to address is a spam trap - pse reply to the group)
Does this help?
How to reveal the Bcc box in Outlook
> Hi, I'm running Outlook 2002 SP3 and need to add the BCC option to my
&...PDF Add-in colors changed to black using Publisher 2007
I have Publisher 2007 which shows it to be Beta2 though it came pre-installed
on a recently purchased PC. Help shows that it is SP1 MSO (12.0.6213.1000)
I installed theMicrosoft Office PDF/XML add-in which works well apart from
where text is coloured. Where is is the case, it is converted to black in the
I have tried High Quality and OCmmercial printing setting and checked
advanced options but can't see any setting which may be causing this.
Design Checker flags the coloured text as being RGB so I converted it to
CMYK but is still gets changed to Black when Publish ...text to rows
I there a way to put text to rows instead of columns? What I am trying to
do is take a cell with reference designators separated by commas and copy
them to individual row.
ex.. C1, C2, C3, C4
You want to "transpose" the data. Highlight the data in the row, then
click <copy>. Move cursor to where you want the columnar data to start
then Edit | Paste Special | Transpose (check) then OK and <Esc>.
Hope this helps.
Just re-read your posting - didn't realise you had the data all in one
cell. Probably easier to use Data | Text-to-col...How do I add the word "Draft" to first page?
I am trying to figure out how to add "Draft" or "Confidential" to the first
page of a document.
Hey DLB - it's easier to add from your printer. Select the effect tab and
use the watermark feature. Otherwise, you'll have to add a background to the
> I am trying to figure out how to add "Draft" or "Confidential" to the first
> page of a document.
Check your printer, especially if the driver has been upgraded since
the printer was installed. Many/most printers provide that...How does one copy subtotal rows?
How does one copy subtotal rows?
Since my access to NNTP is limited, a copy of your reply to
ALEXANDEReBARNEs@Yahoo.Com is especially appreciated.
One usually selects the rows he wishes to copy,
Then hits <F5>,
Then, in the "GoTo" window clicks on "Special",
Then, in the "GoToSpecial" window clicks on
"VisibleCellsOnly", then <OK>.
Now, right click in that selection and choose "Copy",
Then navigate and paste to "wherever".
------------------------------------------------------------------...can't send email from outlook 2000
I cannot send or receive email from my outlook 2000 internet only. The
following error message appears:
A TCP/IP error occurred while trying to send data to the server. (Account:
‘pop.charter.net’, SMTP server: ‘smtp.charter.net’, Error Number: 0x800ccc13).
Can anyone help me with this? Thank you in advance. Orlando
coalcorona <email@example.com> wrote:
> I cannot send or receive email from my outlook 2000 internet only.
> The following error message appears:
> A TCP/IP error occurred while trying to send data to the server.
> (Account: ‘pop.charter....Can I use Excel to calculate VAT?
I'm a very new user of Office and have very little clue of whether or not
such things are possible. Any help would be much appreciated.
Exactly how you do it depends on your tax laws but these formulae should
get you going. In each case I have assumed the starting data is in A1
and the VAT percentage is in B1
Calculate VAT to be added to a base price
Calculate selling price from base price
Calculate Base price from retail price
Depending on accounting rules you may need to use Roundup or Rounddown
to get the ri...I can't get pictures to appear when I insert tem in a frame.
when I insert a picture file into a document, it does't appear on the sceen
but seems to be there nevertheless.
Do you have View, Pictures, Detailed display enabled? If not maybe your video
card needs upgrading.
Read the fourth FAQ here:
"Kilno" <Kilno@discussions.microsoft.com> wrote in message
> when I insert a picture file into a document, it does't appear on the sceen
> but seems to be there nevertheless.
...Can I stop CEdit Beeping?
I am doing this with a CEdit control:
I am sure nBegin and nEnd are legitimate values. This creates a Beep but
seems to be working fine.. Is the beep an error notification or a normal
CEdit response which I can turn off?
"Jona Vark" <firstname.lastname@example.org> wrote in message
> I am doing this with a CEdit control:
> m_ceShadow->SetSel(nBegin, nEnd);
> m_ceShadow->ReplaceSel(_T(" "));
&g...Can't See Original Post
I have a post in live.mail.desktop that I posted 1/27. I have since
formatted my HD and reinstalled WLM. I see my original post in Windows Mail
in Windows Live Mail.
I have downloaded all headers.
Anyone have any ideas how I can see my original post?
Your Jan 27 post shows up here
Vista Basic x32 sp2
I'm trying to fix problems with WLM soi I decided to uninstall it and
when I select 'Windows Live Essentials' in 'Programs and Features' and
'Uninstall' nothing happens. If I click 'uninstall...this will not compile or maybe I can't do this in an addin
I can add a named shape "copywrite" to any slide and with these two modules..
any time i mouse over the afore mentioned shape I get the desired message.
Question 1: can i simply compile this as an addin to save me writing these
modules in each presentation?
Question 2: If so why won't it compile?
Im just aiming to have this addin and anytime i have any presentation running
with shape "copywrite" i get the message.
Thanks in advance for any thoughts.
Sub OnSlideShowPageChange(ByVal Wn As SlideShowWindow)
Dim CurSlideInd As Long
Wit...Opportunity add to two contacts
I want to add a opportunity to two contacts. One wil be the customer and one
will be the related person. When i display opportunity under the contacts i
want to see the opportunity .
You have not mentioned if its CRM 3.0 or 4.0. In 4.0 you can add additional
relationships with the Contact entity to get the lookup to associate another
In 3.0 it is not allowed to add another relationship. This can be achieved
through unsupported scripting though.
Hope this helps!
Innovative solutions fo...Office X Education
As a student, I purchased Office X for the Education price, and the
installation CD is labelled "Academic".
Now that Office 2004 is out, can I simply purchase the upgrade?
I seem to remember being told this was ok when I bought Office X, but can't
find it mentioned anywhere now.
All the best,
In article <email@example.com>,
"J.William Kay" <firstname.lastname@example.org> wrote:
> As a student, I purchased Office X for the Education price, and the
> installation CD is labelled &quo...Where can I find an inventory template for excell?
I work in a warehouse and I'm looking for some type of inventory template.
Maybe one of these templates at Microsoft will help:
> I work in a warehouse and I'm looking for some type of inventory template.
...Can I use MSComm in C++ console App?? How???
I am tring to write a console app that interfaces with the serial port.
I would like to use MSComm if possible. I pretty much know how to do it
using an MFC or a dialog app but can't see how to do it for the
MSCOMM is so much more difficult to use than raw serial port interfacing that it is not
clear what value it adds.
On 19 Oct 2005 16:28:10 -0700, "salsipius" <email@example.com> wrote:
>I am tring to write a console app that interfaces with the serial port.
>I would like to use MSComm if possible. I pretty much know how to do it
>using...how can I print on a 8.5 x 5.5 sized postcard?
We have pre-printed 8.5 x 5.5 sized postcards and I want to print something
on the back through the printer and can't seem to be able to set it up to do
one on a half sheet. Any ideas?
You need to set up the paper size in Publisher and in the printer driver.
MVP Microsoft [Publisher]
"Karen Kounter" <Karen Kounter@discussions.microsoft.com> wrote in message
> We have pre-printed 8.5 x 5.5 sized postcards and I want to print
> on the back through the printer an...How can move 3000 users .PST files to a read only NAS ?
Arghh.. Please MVP's I need your help
Last year we upgraded to Exchange 2003. 2 companies merged to form a
new one. (not a take over)
So we had no upgrade option other than creating as it happened a new
domain name, servers etc.
In order for people to access their old emails we exported them from
each of the 2 old exchange servers.
This has left us with 3000 pst files. Unknown to me until recently the
server where the pst's reside had it permissions so that people could
add/delete from their PST files. This was not what was agreed and I now
have to change this. But I since discover...How can I set my Outlook 2007 to save email addresses when sent?
I would like for Outlook to remember email addresses that I send/reply to
and give a predicted email addy of the recipient. Is this possible?
See if any of this info helps you
TX Realtor wrote:
>I would like for Outlook to remember email addresses that I send/reply to
>and give a predicted email addy of the recipient. Is this possible?
Message posted via http://www.officekb.com
...Customer Rewards Add On
Is anyone aware of an RMS add on that would generate customer rewards? What
I would like it to do is for every $250 a customer spends, our system would
automatically print a receipt/voucher for $25 off their next purchase.
Retail realm has one that does just that.
"Kris" <firstname.lastname@example.org> wrote in message
> Is anyone aware of an RMS add on that would generate customer rewards?
> I would like it to do is for every $250 a customer spends, our system
> automatic...When I add data to my chart it changes my chart type-Help!!!
I cannot get my chart to stay the same chart type when I add data for March.
My co-worker can do it on her computer. I am wondering if one of my settings
is different from hers. Can you help?
No, I cannot help. And I doubt that anyone else can help.
Unless you describe the worksheet data, the original chart type, the new
data you are adding to the chart, and the new chart type.
"Jbear" <Jbear@discussions.microsoft.com> wrote in message
>I cannot get my...How to add coding button on tooolbar
This is a multi-part message in MIME format.
I am using Outlook 2003 English Edition(plus Windows XP English). I =
always receive email in different Language. If the email is not in =
English, every time I have to open this email and go View and Coding, =
then try different Coding, until the email displays in right language. =
so how to add coding button on toolbar then I can make my email reading =
------=_N...Macro code mod
The macro below allows users to group/ungroup rows in a protected sheet.
Question: how to modify the VB code so I can incorporate additional tab names
or better yet, have the macro apply to the entire workbook?
Thanks in advance for your help,
.Protect Password:="xlhelp", userinterfaceonly:=True
.EnableOutlining = True
For Each sh In Activeworkbook.Worksheets
.Protect Password:="xlhelp&q...Depreciation issue with Fixed Assets
I am hearing that there is an issue with fixed asset module in GP from
customers. Is this issue being solved by Microsoft? who at MS would have info?
The issue is the way GP handles depreciation expense in non-standard fiscal
years – I’ll use a 7 month fiscal year for example.
If a company changes from a 12-month fiscal period to a shorter period (say
to align themselves to a 09/30/xx FY date) and the resulting ‘short-year’ is
7 months long, the Fixed Assets system will recalculate depreciation for all
their assets for that short fiscal year. It will compress a...