Autofit Row Height #3
I have a column on sheet 1 that is set to wrap text so that the row height
increases and decreases as more text is entered into the cell. This works
Users enter a number on sheet two where there is a lookup function that
returns the appropriate text from sheet 1. The problem is that when the text
is returned by the function, the row height does not adjust to fully display
all of the text in the cell. Is there a way of automating this?
Any help would be appreciated.
...RMS Troubleshooting and Basic Set up v4/3/2005
I have decided to post the information on the net because ms newsgroup does
not have a long message retention.
...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...columns in RMSSO
Is it possible to change the columns on the forms ??
Receiving po contains:
Type, Item Lookup Code, Reorder Number, Description, OtyOrd, QtyRTD,
QtyRcv, Cost, Price, NewPrice, Extended
Item Lookup Code, Description, MPQ, Price, BinLocation
We need to modify few other forms as well.
I think I've seen that in one of the add-ons while ago, but I cant
remember which one was it and I'm not 100% sure if I really did.
...Reference column question
Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is
when I do my formula which is a subtraction for each column,I want to use a
refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so
to=Sum(P1-D3)Rather than enter each manually,because cut and paste adds 1 to
each column how can I get to use f1 as reference for that column G1 for that
If I understand correctly, try putting a $ in front of the row reference.
Also, sum is not necessary for what you are doing.
as you copy that down it becomes
copied across to the ri...Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?
Thanks in advance.
----------...Wild curser #3
> Your scroll lock isn't on ... is it?
No, it isn't- thanks! I've tried putting it on and off a few times
just to double check.
...All Columns are not to move
How can I stop the columns from moving to the left of the Table?
On Sun, 3 Feb 2008 17:28:39 -0800, Roger <Roger@discussions.microsoft.com>
>How can I stop the columns from moving to the left of the Table?
You'll have to explain what on Earth you're talking about, Roger. What columns
are "moving"? How?
John W. Vinson [MVP]
Good evening John,
I found my own answer:by bringing the cursor to the first cell, the first
column will not scroll to the left anymore; however, when I bring the cursor
to any other cell and scroll to the rig...sending attachments #3
I downloaded all the security updates for Outlook 2000.
Now Outlook can't send attachments. The attachments
appear in the "send" directory, but the receiver of the
email gets no attachments.
The Outlook security feature blocks attachments that are potentially unsafe. This security feature provides an additional level of protection against
malicious messages. Although Outlook 2000 SR-1 or Outlook 2000 SR-1a blocks access to the attachment, the attachment still exists in the message.
For more information on resolving this issue, please refer to Knowledge Base art...Synchonization with SFO 3.0 performance
I would like to know if the syncronization of the Sales for Outlook has
better performance in release 3.0 ??
Is there a place i can find information on the way the new SFO is working ?
I was meaning 'Is there a place i can find information on the way the new
SFO is built' . Does it still use Cassini ?
> Hello everyone,
> I would like to know if the syncronization of the Sales for Outlook has
> better performance in release 3.0 ??
> Is there a place i can find in...Text-To-Columns Fixed Width
When using Text-To-Columns, Excel "recognizes" that the data fits the Fixed
Width criteria and PRE-assigns the width.
In most of the cases I work with Excel is wrong 99% of the time.
Is there a way to force Excel to NOT pre-assign the width (leave everything
On the first panel of the wizard click Delimited, then on the second
panel click space as the delimiter.
Hope this helps.
On Feb 4, 12:50=A0am, TP <T...@discussions.microsoft.com> wrote:
> When using Text-To-Columns, Excel "recognizes" that the data fits the Fix=
> Width ...How to get total "conditional sum of cells" in a column?
I have dollar amounts in one col, and status in another. I want the
sum of those dollar amounts where the corresponding status cell is
empty (blank). How do I do this?
Thanks for any hints,
Status in Column A and dollar amounts in Column B:
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"sherifffruitfly" <firstname.lastname@example.org> wrote in message
news:email@example.com...Publisher help #3
I created a website and i am able to upload it and view it in firefox but not
in any version of IE. Not exactly what i did wrong. But any help would be
Repost this question in microsoft.public.publisher.webdesign newsgroup and
add the URL to your problem website.
Microsoft MVP Expression
"Astroda" <Astroda@discussions.microsoft.com> wrote in message
> I created a website and i am able to upload it and view it in firefox but
> in a...Delivery Status Notification (Delay) #3
I have been receiveing several message stateing thet my message has been
delayed. Why is this happening and is there a way to configure this so that
the message does not become delayed?
below is a copy of the message that i receive;
This is an automatically generated Delivery Status Notification.
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
...Sort column with first and last name by last name
I have a mailing list with 10,000 names. The first cell has first an
last name in the same cell. First name is listed first. Is there
formula to sort and/or separate text in a cell. I would like to sort o
separate the first name from the last in the cell to allow for a mai
merge by name. Using Excel 2002. Thank you
Message posted from http://www.ExcelForum.com
If you have just first and last names separated by a space, Data>Text to
Columns would be the easiest method to split into two columns.
If more than that, like names with van or von or de etc. you may need a
different m...Integration GP 8.0 with CRM 3.0
Hi. i'm newbie in GP but i have been know CRM 3.0, i want to do integration
between GP and CRM using Microsoft Dynamics CRM Connector for Microsoft
Dynamics GP. After all installation and configuration, the integration was
work. I add an account in CRM then the account which i was added is display
in GP (as customer). But why the order between GP and CRM can't integrate? I
was follow the instruction in the integration guide. The guide book says that
the tax details, tax schedules, shipping methods, payment terms, unit of
measure, unit of measure schedules, price groups, price le...Multiple e-mail addresses #3
When a Contact has multiple e-mail addresses, how do I set
one of them as a default? Now, emails are going to ALL of
their addresses. Thanks-Rose
...Finding unique numbers in a column
Is there any way to find the number of unique values among a set o
values in a column in an excel sheet. I would also like to know th
number of times each value appears in the column.
coolkid397's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2431
View this thread: http://www.excelforum.com/showthread.php?threadid=37924
There was also a similar thread under Excel Worksheet functions titled
Solution provided was to use:
I installed SBS with sr 1 server service pack and SBS sr1 service pack and
On the same server I can browse the mailbox with internet explorer on
Outlook web access when i created the same account in Outlook express on the
same server when i do F5 it dose send and receive mail but it dosenot
downloade messages in Outlook Express .
Sarosh Tafti <SaroshTafti@discussions.microsoft.com> typed:
> I installed SBS with sr 1 server service pack and SBS sr1 service
> pack and Exchange Sr2.
> On the same server ...Multiple IF Functions #3
I'm new at this and am trying to put several different, unrelated IF formulas into a single cell but am having trouble with it. How do you differentiate between one formula and the next, but still have it in the same cell
Is there a limit to the number of IF formulas you can put in one cell? If so, how many?
There is a limit of 7 nested IFs in a cell.
A simple multiple IF scenario could be:
=IF(A1<5,"under 5",IF(A1>5,"over 5","5"))
This checks the value in A1 and gives the result in text. If the first IF
returns FALSE, it continues into the next IF ...Circular Reference Warning #3
When I open my exel file .. this pop-up open ..
circular reference warning
one or more formulas contain a circular reference and may not calculate
correctly. circular references are any references within a formula that
depend upon the results of that same formula. for example, a cell that refers
to its own value or a cell that refers to another cell which depends on the
original cell's value both contain circular references.
for more information about understanding, finding, and removing circular
references, click ok. if you wnat to create a circular reference, click
cencel to cont...Stacking columns!!!
I have columns with headings like:
NAME - AGE - EXPERIENCE.
I have many sheets like this and I have to import all of them into on
sheet -- where all the entries are stacked one below the other.
There was already an enquiry about this in this forum -- but there wa
If any has a solution, it would be appreciated.
kmsubbu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=844
View this thread: http://www.excelforum.com/showthread.php?threadid=276...Help with column
I have a datafeed that comes to me everyday i need to format one column
of around 1000 rows so it multiples the total column but a 1000 so
getting rid of the decimal point i.e =A3100.00 becoming 10000 , i also
need to do this using a macro. can anyone help=20
Dim iLastRow As Long
Dim i As Long
iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To iLastRow
Cells(i, "A").Value = Cells(i, "A").Value * 100
"lennymos123" <firstname.lastname@example.org> wrote in message
news:1115651206....Column and Row reference
How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references
Uncheck "row and column headers".
Good idea to spend a few minutes browsing through the various Tools>Options
tabs to see what else is available to toggle on/off.
Gord Dibben Excel MVP
On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com>
>How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top an...Sending Email #3
I am able to receive but not send email, with the
following error message: "553 authentication
required" "check email properties". I can send sometimes
if I go in and re-enter my password but once I close
outlook and re-open, it will not send. Its unpredicable
and causing large problems for my business.
You can set up the required authentication on the "Outgoing Server" tab in
your e-mail account properties.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve t...