How to Past cells with formulas not using "$" without changing ref
I would like to copy / past a large amount of cells in which "$" has not
been used in formules. Problem : referenced are changed (because "$" is not
Example in A1 : "=B1+C1"
if I copy A1 to A50 : the contained formula will be : "=B50+C50" while I
would like it to be "=B1+C1 without having to insert $ in formulas
Please could you telle me if there is a way to do so ?
many thanks and kind regards.
A few thoughts...
First, it might be easier to add the dollar signs before copy/past...Special character in Input Message
I'm building a message in the "Input Message" tab of the "Data Validation"
Manually, I can add a special character that is a large black triangle
pointing to the right like a bullet. However, I can't seem to produce this
character using code.
Can someone please post an example where I can insert a special character
...Multiple Excel Charts to PowerPoint
OK, I think I have a question that will stump even the best of you! :)
I have several worksheets that contain multiple charts. I want to copy the
charts from Excel to PowerPoint with one chart to a slide. I can do so one
at a time by copying and pasting them. The drawback is that it takes lots of
time to do this because I'm working with 250+ charts. My question is if
there is a way to quickly export the charts to PowerPoint so that each slide
contains a different chart.
Partway through this article you'll find programmatic approaches to that
http://peltier...Problem installing up sample data
CRM install went fine. I go to select the user who will
run the sample data import wizard, and there isn't one
listed. Should I create a new user in AD under
Adventureworks & User Manager just to run the import? The
manual gives the impression that there should already be
a user listed(I'm assuming the administrator account).
Thanks in advance,
...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...Excell - organization chart
Is it possible when working in an Excell organizational chart to attach a
co-worker to the top level as when their are co-directors. I cannot find a
way to do this. At the top level, the co-worker selection is not available,
only the assistant or subordinate.
did your try microsoft organisation chart 2.. Insert object and check
microsoft organisation chart 2.0 . Here two managers are possible mine excel
codirector to top level of org chart <codirector to top level of org
email@example.com> wrote in message
news:C109C8A8-FBC3-44A1-B675-2620C9EB3A68@microsof...Unable to edit recurring Appointm.
one of my Users (outlook 2k+Exch2k) isn�t able to edit, open or delete any
recurring Item (Appointment) he entried before.
Help is much appreciated
"muh" <firstname.lastname@example.org> wrote in message
> one of my Users (outlook 2k+Exch2k) isn�t able to edit, open or delete any
> recurring Item (Appointment) he entried before.
> Help is much appreciated
Replied in m.p.exchange.admin. Please don't multipost - if you need to post
to multiple groups, it's best to crosspost inst...How would I plot this kind of data in a line chart?
How would I use chart wizard or whatever to plut these 5 data sets.
I'd like to do it w/ lines that are either straight or 'smoothed'
between the data points and visual accuracy. For some reason I'm
hitting a blank on figuring out how to format the data in a
spreadsheet so it can lend itself to a nice chart showing different
A B C D E
0 @ 1000 0 @ 1000 0 @ 1060 0 @ 865 0 @ 1200
10 @ 1700 10 @ 1700 2 @ 1340 2 @ 1325 2 @ 1460
na na 17 @ 2400 11 @ 2400 12 @ 2200
26 @ 5000 26 @ 5000 24 @ 48...Unable to create new user on CRM 4.0
I've a problem with my CRM 4.0 server.
Since I use dcpromo on it (at first the CRM 4.0 server was DC and now
it's only a server) I can't create new user on the CRM.
The CRM works perfectly with the actuel user but I can't create/
The message is in French, it's quite simple :(
No info in the message, it just says me that an error has occured...
I tried using the 2 methods in the CRM, it's the same error
I don't know what can be the problem, and I don't now what do to ...
I need help
Potentially to do with Network Service a...Export outlook task items to Excel
I am trying to analyse outlook task items stored in
Exchange Public Folder using Excel 2002. Can someone
help me how to export task from Public Folder?
...Unable to open .xls file
I have Windows XP Home edition on my computer and I received an email with
some info that is an .xls extensoin. I have Windows Worksheet and wanted to
know how, if I could, look at this file? I also receive info with >pps
(powerpoint) and am unable to open these files also. ANy suggestions?
You may not have MSOffice. It's not part of Windows. It's a separate suite of
But MS does make a viewer for excel:
and one for powerpoint:
http://www.microsoft.com/downloads/details.aspx?Fa...How to create 3 axes chart based on three series of data
...Prevent Hidden Column data from being copied/pasted?
A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions wou...How to read LPBYTE binary data? #2
I have a variable LPBYTE which contain a binary stream data. I know the
packet structure of the data but I am not sure how to read it.
String 6 (header)
U16_TYPE 2 (sequence number)
U8_TYPE The remaining
Can anyone give me some idea? Thanks!
> I have a variable LPBYTE which contain a binary stream data. I know the
> packet structure of the data but I am not sure how to read it.
> Packet structure
> Type Length
> String 6 (header)
> U16_TYPE 2 ...Excel function help
Hi 2 all.
I need help for a little problem.
I've 5 row with 6 record, for example:
| Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink |
|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|----------------------------...How to make List created refer by another worksheet data?
My table to check manpower overtime result base on daily working overtime.
Header in 1st row :
(A1)Index No. (B1)Name (AL1)Overtime Total
(Hundreds of employee name...)
Overtime total daily changes base on daily updated data on Column (C:AK)
In second worksheet i make daily updated summary employee that overtime
taken over than 80 hours only
(A5)Index No. (B5)Name (C5)Overtime <80
(Display employee which overtime more than 80 Hours only)
How to make 2nd page updated automatically everyday??
Excel provides for an On Open macro... The macro with the name auto_op...Internal HD showing explorer but not in Disk Manager and unable to
I have a HP workstation DC5100 with Windows XP with SP3 installed and I have
two internal hard drives. I was attempting to defrag the hard drives and
getting an error that Disk Defragmenter could not start. After some
troubleshooting I notice that in Disk Management that the internal hard
drives did not show up and only the DVD drive was showing, from the command
line utility diskpart when I listed the disks. I have attempted to do a
chkdsk on reboot however it flash by so quickly that the only thing I cathc
is something about RAW drives then it skips the chkdsk. I have done ...Unable to add item to shared calendar
I am trying to add an item to a shared calendar by double clicking on a
date/time. I immediately receiving the error "The operation failed - An
object cannot be found". I have several users calendars that I have access
to and they all seem to work but this one. It has worked in the past week
but all of a sudden quit working this week.
I have tried the following:
-removing the shared calendar and re-adding it
-Detect and Repair
Any help would be appreciated.
"butter" <email@example.com> wrote in message
news:5BBC0248-8E7B-45B3-9...Pivot table formats text data with 2 decimals
My source table has a vlookup field using general format that looks up
a value in a separate table also using general format. The data is
either alphanumeric or numeric (ie: TX1 or 4, or 5, etc.). I have
tried changing the formats to text with the following results.
When I run a pivot table using the source table, one of the row fields
(for grouping) is this lookup field. Excel displays the results that
resemble numeric data with two decimals and offers no formatting in
the pivot table options (like it does for data fields).
I can change the field format, but refreshing the pivot table a...Choice of Data system
I'm a student and I'm currently developping a backup application in MFC
(C++). My app basically consists of a Treeview and a listview control which
holds all the files I want to back up and the ones that have already been
My problem : which is the best solution for saving my data (treeview
structure with files info ...). I think that loading the whole tree
structure (and file list and info...) would take too much memory.
I thought of using a database to store all my data. What do you think ?
I need to be able to quiclky search for data, for example when the user
select...how do I do an if then query in excel from 2 sheets?
I have 2 sheets in excel... I need to do a query that says IF a number is
input into a cell (in a large array) in sheet two, THEN the name that
corresponds in that row will be input into a cell in sheet one.
ARGH PLEASE HELP!!!
You can use a vlookup.
"Kerry" <Kerry@discussions.microsoft.com> wrote in message
news:3F012692-2196-...Excel and Outlook failing to communicate
I recently installed Office XP on my new computer and I'm
unable to send an Excel workbook sheet in the body of an
email. I keep getting an error message saying that Excel
was unable to start or find Outlook. The error message
tells me to verify that office is installed correctly and
that my email is configured properly. I've reinstalled
Office and my email is functioning properly.
I'm at my wit's end here. Can anyone offer an assistance?
Is outlook set as the default email client? Are both outlook and excel the
Diane Poremsky [...Unable to record macro
When recording a macro an 'Unable to record' message appears when I try to
record a formula. Here is the formula that seems to cause the problem:
Anyone know why this should happen?
Thanking you in advance.
Sorry that is a typo error, even with the correction the error message still
"PC" <p...Unable to open default mail folders. MAPI was unable to load the Gwmspi.dll.
Removed groupwise to switch to outlook and the following
error occurs when stating outlook. I cannot access the
KB article that deals with this subject.
...resize charts to paste into powerpoint/word
I have created a number of charts as stand alone sheets. I now want to resize
these charts so that they are in the dimensions of the ppt or word table,
that I would like to paste them in. Forgive the lack of precise terminology,
but the sheets take up the whole screen and are not surrounded by the grey
plot area. How do i get the grey plot appear to signfiy that my dimensions
the chart have changed. when i press, FILE PAGE SETUP and alter the
dimensions, the grey borders do not appear
Go to the Tools menu > Options command, click on the Chart tab, and uncheck
Chart Sizes ...