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...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...Looking for Excel Help
I'm a very novice Excel user and am looking for a little help with
creating a formula for a spreadsheet I'm creating for
my personal use. I would appreciate some
assistance if possible. Thanks in advance.
Message posted from http://www.ExcelForum.com/
Post a sample of what you want to do.
Your question is just a tad open ended <g>
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"DanB4105" <DanB4105.ywtpa@excelfor...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 ...Please help #8
I have Exchange 2000 and Outlook 2003 in Cache mode. Has anyone seen this or
know how to fix it?
Task 'Microsoft Exchange Server' reported error (0x8007000E) : 'Out of
memory or system resources. Close some windows or programs and try again.'
"John S" wrote:
> I have Exchange 2000 and Outlook 2003 in Cache mode. Has anyone seen this or
> know how to fix it?
> Task 'Microsoft Exchange Server' reported error (0x8007000E) : 'Out of
> memory or system resources. Close some windows or programs and try again.'
>...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?
...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?
...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...Emails #3
I was wondering if anyone knew of any web based email provder that I
could use that wont be bloked but the I.T Filer at my work. I require
use of emails during the day for personal use but work emails are
monitored. I have tired various sites i.e Hotmail, Yahoo, Gmail, lycos
etc but they are all blocked. Does anyone know of any that may not be
picked up buy the web filer.
It is difficult to answer because it depends on what your filter is and how
it is monitored. For instance, if it is actively monitored and somebody
found out you were accessing the site, then it coul...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 ?
...learning Excel #3
I was considering learning Excel as an additional tool for my data analysis
Is it better to use data sets that I have previously used with SPSS and
apply the same analysis tools as in SPSS? For applying the appropriate
tools, I was considering using excel's online help.
The second option I have is to use some excel book for data analysis and
apply the techniques to data sets provided with the book.
...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
...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...Items in this message are still loading. Please wait a moment and try again.
Get this error message when trying to print an HTML email using Outlook
2002 10.6515.6735 SP3. I've seen lots of single post threads regarding
this issue with no responses. The problem is, the moment lasts up to
an hour. Are there any settings that can be tweaked to speed this
process up? Could it possibly be a printer issue? This just recently
started happening. Any suggestions are appreciated.
I haven't ever experienced this but are you on a slow Internet connection?
An hour is an awful long time (which I'm sure you know already)
"Geoff" <geoff.warner@gmail...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
...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...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 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 ...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...Outlook still won't start
After over a year of flawless operation, suddenly my
Outlook won't open. When I try to open it, the logo pops
up, then I get the following error message: "Cannot start
Microsoft Outlook. Unable to open Outlook Window"
I ran detect and repair to no avail!
I then wrote to this forun, and after Russ Responded, I
took his advice and renamed the file "outcmd.dat" (with
Outlook closed) to clear the toolbars. I searched my hard
drive for a file called outcmd.dat and renamed it to
outcmd.old then restarted Outlook (as this didn't cure my
problem, I renamed the...