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
...Unable to open .docx documents in Word 2002
I cannot open word documents sent with .docx extendion in word 2002. I
checked my language setting and it is English. What is wrong?
Download the Compatibility Pack.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Johnpm" <Johnpm@discussions.microsoft.com> wrote in message
>I cannot open word documents sent with .docx extendi...owa cant open ppt attachments
i have an exchange 2003 cluster
when a user tries to open or save a powerpoint attachment it hangs at 97%
all other attachments open fine
...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...Stop My Documents from opening all the time?
Is there anyway to stop My Documents from opening everytimg I start a
Windows Explorer session?
I guess there's no future in trying to delete it, because so many products
try to put stuff there. Right?
> Is there anyway to stop My Documents from opening everytimg I start a
> Windows Explorer session?
If you want Explorer to open somewhere else, simply modify the
properties of the shortcut you're using to open it. All you need do is
create/modify the target field of your Windows Explorer shortcut to
point where you want it.
Co...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...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
...Pivot Table Question #5
How do I make the row headers show up in front of each row
on pivot table instead of just once on the first row of a
Copy the pivot table
Do a Paste Special > Values into another sheet
Ensure that the top left cell is A1
Run the Sub FillBlanks() below
(from MVP Debra D)
'by Debra Dalgleish 7-Dec-2001
'fill blanks cells with data from above
.FormulaR1C1 = "=R[-1]C"
Range("A1").PasteS...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?
...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 ?
...Great Plains Certifications
I recently wrote the Great Plains install and configure exam. for anybody
that is planning to write it, I can say that the exam is fair and does not
cover any material not in the manual.
I would like to write the financials exam as well, but I need some guidance
or direction as to what material to focus on. i do have all the manuals, but
please let me know if you are aware of any additional resources.
There are preparation guides available for each exam out on PartnerSource.
This guide lists all the different offerings available that can help yo...cannot open hyper links in outlook
when I try to open a hyperlink in outlook, I get the following message: This
operation has been cancelled due to restrictions in effect on this computer.
Please contact your system administrator. ----- I am the system
This is a problem with IE, not Outlook.
You need to reset your internet settings in IE's Tools, Internet Options,
Advanced tab. (Or Control Panel, Internet options, Advanced tab).
See http://www.slipstick.com/problems/link_restrict.htm for more
"Donald McNeely" <Donald McNeely@discussions.microsoft.com>...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...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
...Business Portal should allow requisition to be added to issued PO
The printing of a PO changes the status of the PO from New to Released
(signifying the release of the PO to the vendor). Once a PO has been
released, it will not show as a PO you can add items to from business portal.
The current design of the product only allows you to add to POs with a status
of New. Adding an item to a Released PO should trigger a change order.
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 you do not ...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...Business Portal Development
I know how to use Rational XDE, VS and the BP SDK to create new entities in
BP, but how does one go about chaning labels?
For example, if I wanted to change two labels on a requisition mgt screen:
Can I just crack open the ASPX page and change the caption property?
To edit the lables you can use front page server extensions 2003.
"Dwight Specht" wrote:
> I know how to use Rational XDE, VS and the BP SDK to create new entities in
> BP, but how does one go about chaning labels?
> For example, if I wanted to ch...2 different Qty in order details in northwind
im pretty new with access 2007, i decide to use northwind template.
In order detail both form, i have 2 different Qty, the original Qty is the
Qty that will link to Inventory and I add another field Qty1 for invoice
purpose. For example, I got 1 roll of tape, 1 roll will be cut into 10 pcs.
We need to bill according to customer request qty 10, but actual qty sold is
only 1. Anyone come across this issue. How to modify it w/o effect the
table/form as below:-
QUANTITY (FOR INVENTORY)
QTY1 (FOR INVOICE)
AND SO ON
Is there a...form base authentication #2
This is killing me. I'm implementing form base authentication. I have SSL
and everything working but for one problem
when use won't to get to owa they type mail.domain.com which then defaults
the problem I'm having is that FBA need it to default to https not http.
How can I get it to default to HTTPS with out telling the uses to type
I am implementing this on a FE/BE environment
What I do is change the http port on the main site to something like 8080,
and then create a new site that listens on 80. For that site, instead of...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...Automatically copy input from one cell to another
After I enter a value in one cell, how can
I have it automatically enter it into another cell,
within the same worksheet, or into a different worksheet.
Message posted from http://www.ExcelForum.com
If you enter the value in A1 of sheet1, put this in the other cell in
or in another worksheet:
In article <firstname.lastname@example.org>,
picktr <<email@example.com>> wrote:
> After I enter a value in one cell, how can
> I have it automatically enter it into another cell...Exchange 5.5 Restore Problem
I have an Exchange 5.5 server (SP4), running on NT 4.0
(SP6). We back it up with Backup Exec 8.5, with the
Exchange Agent option.
I am now in need to restore an old copy Information
Store, from a last year's tape, to recover some
information. I put together a server, with Exchange
5.5,NT 4, etc. All Service packs etc up to date, and
Exchange was working fine. I then proceded to restore the
Information Store. The file size of the priv.mdb appears
to be correct, however, since the restore, the info store
won't start. I receive the following error when trying to
start i...Reference / Copy Dynamic Data
Have a worksheet listing products and prices for numerous suppliers.
This worksheet will change often.
What I would like is to reference this information on other worksheets.
I would also split the info onto a worksheet for each supplier.
Therefore i will have a worksheet for ABC and for XYZ, and the info in
these worksheets will change as the main "index" worksheet changes.
Worksheet ABC contains:
...Cannot read return from Axis webservice
I have to invoke an Axis webservice, however, the service returns a soap
message without the xml declaration line, so .net returns a null reference.
Is there a way to easily tell .net to ignore whether the xml declaration is