More Columns #2
I am using all columns through IV on one of my
worksheets. Does anyone know how to get more columns?
know way using Excel. this is the maximum!
Stacy Haskins wrote:
> I am using all columns through IV on one of my
> worksheets. Does anyone know how to get more columns?
As Frank said, that's the maximum cols
But maybe you could try transposing your table / data ?
(Excel has a lot more rows than columns)
If so, try: http://tinyurl.com/2nmyy
for an example on using TRANSPOSE()
For a one-time Tranpose:
Copy > Paste Specia...Highlighted word wont DEL when I use Bakspc only in office/word
When I highlight a word in and hit the Backspace key it will not delete the
word, this is only in outlook and word , however I can delete using the
backspace key using one key stroke at a time.
In Tools > Options > Edit, check "Typing replaces selection". (In Word 2007
this option is at Office button > Word Options > Advanced.)
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
backspace key not working correctly wrote:
> When I ...conditional formatting sort
Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Thanks for your time and assistance.
On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
You can't sort by color, but you can add a column to your query like
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.
>Is there a way to sort after condition...Reporting from Project Server
I dont know if i need to ask this question here or in the Access section. I
have an ODBC connection to the Project Server database so I can make reports
through Access. Access' limit of 255 fields per table is causing me some
trouble. for example, the MSP_VIEW_PROJ_PROJECTS_ENT table has well over 255
fields. Access only shows me the first 255 fields. how can I change that so I
can see all the fields in that table?
I have not tried this yet it may be a viable option. Have your DBA create a
view that pulls the key fields to this table and the specifi...projecting the notes pages in PPT 2007
I want to project my notes pages to an on stage monitor in while my presentation (sans my notes) are projected behind me...I will run my notes from a second computer... How can I do it?
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# : Image operations performer
See if Presenter View will do what you want with your set up:
PowerPoint...Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...Linking files 2 ways
I have a work book that is linked to another and vise versa.
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...Goal Seek #2
Can anyone tell me a little about goal seek?
basically it's used to change an input variable so that the result of the
formula equals what you want it to ...
say i have the following
A B C
1 10 20 =A1+B1
now C1 will give me 30, but if i want to know what B1 will need to be if i
want C1 to show 50, i can use goal seek
Set C1 to value of 50 by changing B1
Hope this helps
"Jamie Hart" <email@example.com> wrote in message
> Can a...How do I Remove a Split from my Comments in Excel 2003? #2
I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.
I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.
How do turn this off ?
...Disable Secure Sockets Layer on exchange server when using RPC over HTTP
Hi im trying to enable RPC over HTTP to enable users to establish contact to
my Excahger server 2003 over the internet.
Now, I dont want to use SSL (security not that important) and i am told by
this article that i can disable SSL in windows registry.
Note While RPC over HTTP does not require Secure Sockets Layer, you must
modify the registry to enable RPC over HTTP if you do not want to use Secure
Sockets Layer. Microsoft recommends that you enable and require Secure
Sockets Layer for your RPC over HTTP communications.
At this address: http://support.microsoft.com/?id=833401
But i ...Contacts in Exchange #2
We are running Exchange 2003 and Outlook 2003. I have tried to give a user
rights to her boss's contacts through delegation and setting the rights on
the contacts folder, however, while she has the rights she is unable to add
or see her boss's contact folder in her Outlook. She can see it if she runs
a search, but can not permanently put it in her list of contact folders. IS
there a way that I can accomplish this through the back-end?
...using the journal on outlook
Once I link an email to the journal, can I still find that email in my mail
box? I seem to be able to get to it only via the journal. If this is the way
it is supposed to be, how do I remove it from the journal and get it back
into my mail box? Am I just missing something?
Are you linking to the item or putting a copy into the journal item? Also,
has the item been archived or not?
"Independent" <Independent@discussions.microsoft.com> wrote in message
> Once I link an email to the journ...Offline Synchronization Problem #2
I get the following error when I try going offline. The excelption is taken
from Event Viewer of the Client Machine.
Event Type: Error
Event Source: MSCRMOfflineSync
Event Category: None
Event ID: 6000
Time: 5:03:33 PM
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. saInsert failed for entity
'ActivityMimeAttachment', batchRows=0 with exception System.FormatException:
Index (zero based) must be greater than or equal to zero and less than the
size of the argument li...ERROR: 5.1.2 or other punctuation after the recipient's email address.
I am trying to send a email to a group address I created with 58 addresses
When I try to send the email to this group I get the following Error:
"5.1.2 or other punctuation after the recipient's email address. "
I have gone back to the original contact cards and made sure the addresses
were all legal.
I have re-created the list, same problem
I have re-booted, same thing.
Any thoughts out there?
My wife and I have MBP's and are both running MS Office for Mac's, Entourage
Both of us have messages cued up in the out boxes th...Fixing a formula to read a general format?
A few months ago I had asked a question and got this answer:
I have a a set of values in A1 through A100.
I need to look up each value and find a match in
another set of values located in C1 through C200. If a match is found then I
need the formula located
in column B to return the value in the same row but
the next column over (D).
Copy down through A100.
The formula worked fine, however the reference value and the look up value
are not any more numbers but a combinatio...HOWTO: Customizing CRM
We would like to customize our CRM Opportunity form. We want to
include a OpportunityNumber field, which will be auto-generated when
the new opportunity is created, similar to auto-numbers for Contracts,
Cases, Articles, Quotes, etc. Is it possible and how do we go about
I've looked at CRM Deployment Manager. It's possible to create a
simple custom Attribute for particular object. But I couldn't figure
out how to make it an auto-generated number, like SQLServer
Identity... Could I just modify OpportunityBase table in MSCRM
database? Do I need to change METABASE databas...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...number format with leading 0
Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.
Does that help?
> Dose anyone know how to create a number format that would show a leading zero
> for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
> text format but would like to retain the integrity...Increment A2 from A1 and A2 Sum #2
I have two cells:
A1 - manual value
B1 - automatic increment = B1 + A1
How can i make it?
(=error: circular reference)
Note: I have this formula repeated in some lines:
= B2 + A2
= B3 + A3
Message posted from http://www.ExcelForum.com
...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...Does Outlook use the DAV protocol?
I'm an Outlook Express user who wants to switch to Outlook. I received a
notice from Microsoft that includes the following: "... as of June 30, 2008,
Microsoft is disabling the DAV protocol and you will no longer be able to
access your Hotmail Inbox via Outlook Express."
Please tell me if this action by Microsoft will affect Outlook in the same
manner, or am I free to make the switch.
"BudV" <BudVitoff@(NO)att.(SPAM)net> wrote in message
> I'm an Outlook Express user who wants to switch to Outlook...Can validation lists be enlarged
When a validtion list is created can this be enlarged in a spreadsheet which
has been reduced to view.
for a workaround see:
"AC" <AC@discussions.microsoft.com> schrieb im Newsbeitrag
> When a validtion list is created can this be enlarged in a
> has been reduced to view.