Excel 97 #9
Please can anyone help???
I have two columns in Excel 97. The first contains a list of statu
values eg. pending, or granted or withdrawn. The second contains date
eg.01/12/1997, 05/06/2003. I woudl like to know how to get all th
granted apps before 31/12/2003. Can anyone help please
Message posted from http://www.ExcelForum.com
theres many ways, but an easiest way would be to do a
sort. Highlight the 2 columns, click on data, then sort,
then sort by status, then by date. this should group them
all together. hope this helps...toe
>Please can anyo...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
...Need Help, Task Start Date is wrong
I’m using MS Project 2007, have several task linked with finish to start. I
have set date to schedule from, hours per day set to 8 and Working Monday
My schedule shows Task 1 Duration 4 days, start Wed 6/2/10, Finish Mon 6/7/10
Task 2 Duration 3 days, start Mon 6/7/10, Finish Thu 6/10/10
Task 2 should have a Start Date of 6/8/10 not 6/7/10; what is causing this?
Thanks in advance for your help.
...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...Microsoft CRM 3.0 Installation 11-08-07
Good Day board,
Quick and to the point. I'm installing a trial copy of Microsoft CRM 3.0
that I got at a computer conference recently and I've gotten everything
to work in the System Requirements dialog except that it's telling me
that "The minimum required version is SQL Server 2000 SP4 (8.0.2026)".
Strange this is that I do believe that I have SQL Server 2005 installed
on the machine.
Any idea how to be absolutely sure of what version I have installed?
Have you choosed the right name of SQL server during installation set-
You have to make it sure if it is ...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...New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...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?
...Cannot open Outlook, keep getting Send error report of Microsoft.
We are having problems with Outlook 2003. Everytime we
try to open, we get this: Send error report to Microsoft.
Any ideas why? All windows and office update have been
...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...Document Viewer installer error
I recently ran CHKDSK /F as this was prompted when I attempted to run defrag
etc. Since the chkdsk was run, when I turn my PC on, I receive the following
"document viewier - installed encountered an unexpected error - error code
2908". I click run, the same error just repeats and loops. The only was I can
remove it is to end task via task manager.
Any ideas how I can correct this error?
...I need a macro
I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me the
average of all the entries to the left if the selected cell. EX: I place the
cursor in cell M12.
I want this macro on display in cell M12 the average of all the values from
Col C12 to Col L12. Note that there may NOT be entries in all the cells in
that range. Also the start point would always be col C .Thanks
You can do this easily with a worksheet_selection event in the sheet module
but you would probably want to restrict to a certain range or columns and
rows or it woul...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" <firstname.lastname@example.org> 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 ?
...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
...Installing Active Directory connector?
We are installing a 2003 exchange on a 2003 server in a
2000 domain. We also have a 5.5 sp4 machine running on
2000 sp 4, and once 2003 is installed, we are going to
move the mail boxes from the 5.5 machine. My question is,
do we have to install the active directory connector on
the 2000 Domain server, or could we install it on the
> We are installing a 2003 exchange on a 2003 server in a
> 2000 domain. We also have a 5.5 sp4 machine running on
> 2000 sp 4, and once 2003 is installed, we are going to
> move the mail boxes from the 5.5 machine. My q...SQL 2005 Great Plains 9 issue
I will try to keep this succinct. I am running Great Plains 9 with SQL 2005
on separate servers. Recently I brought up a new SQL server(called sql02) to
replace the old SQL server(called sql01). After installing SQL 2005 on the
new server and restoring all the databases I renamed the new server(sql02) to
the name of the old Server(sql01). Great Plains worked happily after that.
On the new SQL server now called SQL01 there are two database engines in SQL
Studio, one is called SQL02 and the other is called SQL01. I would rather
not have SQL02 there, but I'm not sure how to delet...MOVE TO FOLDER... only appears. I need MOVE TO FOLDER
This is very odd and I've found that I've had this problem before with
not finding icons. Some I've found at the office don't appear here
and vice versa, or they act differently. I have Outlook 2000 in both
places! Very odd.
At home, I couldn't find the HIGH IMPORTANCE icon under the list of
items available in the customize. Yet I have it at work. That's the
one where when the HIGH IMPORTANCE is on, it shows a depressed button
state. I really need that in both places.
Anyway, simple (or so I thought) - I ended up just brining the toolbar
from work on a floppy, a...I cannot get Outlook to send/receive. Error says object not found
I just installed Outlook2007. I cannot get the send/receive to work. That is
when the error says Object not found. If I go to accounts and properties, I
run the two tests and they complete fine. What should I try next? Outlook
2007 is the only new program, all the rest are from Office 2003
IMK <IMK@discussions.microsoft.com> wrote:
> I just installed Outlook2007. I cannot get the send/receive to work.
> That is when the error says Object not found. If I go to accounts and
> properties, I run the two tests and they complete fine. What should I
> try next? Outlook 2007 is ...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...Reply To Email after installing CRM Outlook Client
After installing the CRM Outlook Client, when opening an email and selecting
REPLY, the current windows looses focus. I know this sounds minor but many
of our power users are in the habit of hitting REPLY and typing without even
looking at the screen. It is not until they look up do they realize that the
window no longer has focus thus everything they thought they typed now has to
Has anyone seen this and know of a quick fix?
Thanks in Advance
Have you resolved this?
I have the same problem, and it is VERY annoying.
"Kenneth Clebak&...I need to print a word in PDF from excel.
In my excel Macro, I update several values and then open a word linked
with that excel. Finally what I need to do is to print that word to
PDF. I already have a PDF Printer, so I just need the code to do it.
Can anybody help me?
Thanks in advance.
Habilita la impresora predeterminada como la PDF y ya lo puedes imprimir a
al formato deseado
Tienes alg=FAn codigo para ello?
Desde el panel de impresoras asigno primero la que me interesa y despues
ejecuto mi macro desde el archivo excel asignando la instruccion sig:
midefaultes = a...COUNTIF MULTIPLE CRITERIA #2
To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation.
Adjust range references to suit your situation
Does that help?
"will A" wrote:
> To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation.
> will A
SUMPRODUCT does not work on a complete column, just a defined range, and all
ranges must b...Web Services install error
I keep getting the following error when I try to install web services or
Error Number = 25001 Error Description = [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid column name 'VOIDED'. Error Source =
eConnectInstall90.LoadProcs.AddSQLStoredProcedureLine Number = 240
I have the Web server and SQL Server on separate machine.
Does anyone know what the problem is? When I try to install web services on
the web server, i get this message. When i install econnect on the sql
server, i also get this message.
I finally figured it out. It ha...