Linking multpile tasks to the same date
I am attempting to link the same task (review meeting) in multiple sub tasks.
Each of the sub tasks have the same sequence of events (they are tracking
drawing develepment for an item). I would like to have the review meeting
held on the same day for all of the sub tasks. If one of the subtasks is
delayed, I'd like to see the meetings for all of the subtasks adjust to the
flow of the subtask with the latest meeting date based on the task durations
of the delaying subtask. It almost seems like you would need to create a
circular link to get this to work, but that is not al...links in cells break and revert to user profile location
Hoping someone with great wisom can help.... if a user creates links in
a spreadsheet to cells in other spreadsheets... all ok so far!
if he/she then opens the spreadsheet but the linked files are
unavailable (lets say they are on a disconnected network drive), excel
decides to break the links and revert them to point back at the user's
profile area (C:\documents and settings\etc....)... this is only a
problem if a daft user then saves the file.
My question is - is there a way (reg key or similar) to turn off excel
trying to fix links in this way? what I actually want is for Excel to
ign...How do I link an image to a cell?
I have a list of addresses in an excel sheet and want to print al
addresses on separate cards.
One of the colums contains several names: i.e Joe, Carol, Will
I want for each row (= address) where the cell contains "Joe" tha
excel prints joe.jpg (Joe's signature) on the card etc.
How do I do this based on this excel-file?
Can I do it using Excel? Or do I need Word? Or publisher or
I use Office 97 and publisher 97 but could make use of a newer versio
(2002) if necessary.
~~ Message posted from http://www.E...Import of external data
I have done an export of info from the database system and it comes in an
ASCII comma delimated text format. This file contains things such as names
and addresses and a field called description which can contain quite alot of
info per record. It has been exported with quotes around it so in theory it
should all import into one cell. Instead it is splittting it into many
different cells and is virtually unreadable. If I export the data without
this description it will import no problem into Excel and everything will be
in the correct place. It is only when I export the description with it ...Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help
Desk form in Outlook. We would like the ability to link specific fields
from the Contacts Folder (Example B), in a drop-down list box if
possible. We are far from knowing that something like this is even
possible. Would appreciate *any* suggestions. Thank you.
...FInding external link
When I open a spreadsheet, I get asked if I want to update external links. There
shouldn't be external links in this spreadsheet, so I must have accidentally
left in a formula which I need to change to a value. But I can't find the
How do I search for a formula with an external link in it?
Try Bill Manville's FindLinks addin which is freely downloadable at:
"Fred Smith" <firstname.lastname@example.org> wrote in message
news:up6TR3crFHA.2228@TK2MSFTNGP10....Send to Command - weird issue when using with Mail.app
Operating System: Mac OS X 10.6 (Snow Leopard)
Weird issue here, my signature has our company logo in it and that appears fine when creating a new message inside mail.
When I use the Word/Excel command: File>Send To> Mail Recipient (as attachment) the new email window pops up with the signature intact, then when the attachment is placed in the message (which it does automatically) it strips the logo image from the signature, but leaves the rest of the text there.
I have the latest updates from MS for Office installed as well.
...Linking workbooks #3
I am using winxp pro and msoffice 2003
> We have a workbook with 40 some worksheets in it, each worksheet being a
> listing of products and cost levels for a particular vendor. This is our
> 'master' workbook.
> Each customer has a workbook containing the worksheets of the vendors
> they use. There are about 55 of these 'customer' workbooks.
> I want to link the 'customer' workbooks/worksheets to the 'master' so
> when the prices are changed on the 'master', they will be reflected
> throughout all of the workbook...External HDD Icons change.
Running Windows XP Pro. I have two external hard drives, both
partitioned. They have now changed
the icon to a "folder" when before they had a similar icon as my
internal hard drive & opened
in the same way (double-click) Now I have to open them like folders
ie: with Windows Explorer.
All help appreciated re; returning them to original state.
You can create custom icons for your external hard drives as I do, so that
when youy plugged in the drive its icon will different from the rest (easy
identification). To do this:
-Create your own icon, http://www.rw-design...VPN issues
Recently i have installed Windows Server 2008 on my server in my
basement and deployed it as a file server and a VPN so ica naccess my
Files remtely since im in the military and travel alot. Heres my issue:
From home i can do the following:
Access all shares through my networking
VPN inside the network to the server
VPN to the Routers IP (my server is set to have ports forwarded to allow
Remotely (IE outside my home network)
I can setup the VPN so it shows that im connected and the ipconfig in
command prompt shows the link is active, howev...offline address book issue #2
I am receiving a error "the operation failed" when there is a send/receive
at outlook. I have recevied some errors in the event viewer after enable the
logging on Offline Address Book generator for System Attendant.
Entry '***' has invalid or expired e-mail certificates. These certificates
will not be included in the offline address list for '\Global Address List'.
- *** Offline Address List
OALGen will skip user entry '***' in address list '\Global Address List'
because the legacyExchangeDN 'ADCSuppressReplication' is invalid.
I am running Windows 2000 with Word 2000.
I am trying to link a paragraph in one document to another
document so that when I update the paragraph it
automatically updates in the other document.
I have tried copying then paste special then paste link
(Formastted Tex RTF) then I save both documents.
But it dose not seem to work, What am I doing wrong?
This should be pasted in the Word newsgroups, not Excel.
Anyway, if you update the source document then save it, you can get the
target document to update by selecting the linked field and pressing F9.
Alternatively, i...Linking fields within the same project
Playing around an entry table I realized that I can Paste-Link a value from
a custom, calculated field, into a non-custom field, such as duration, and
that the updates propagate reasonably quickly, without needing to save the
file. That seems to circumvent the 'no calculations in non-custom fields'
dogma. Has anybody used this to do calculations for non-custom fields? How
reliable can this be?
No. You still can't get a formula into the built-in field, but your way does
it by the back door.
Some fields are calculated by MSP only, not user input, so you can't do ...Looking for Followup response re: linking Contact Info. into Accounts
I recevied a response from someone named Dodd on Wed. April 28th in the
evening. The email stated that they would post a response with a possible
'work around' solution on Thurs. April 28th. I am still waiting for that
Thank you in advance.
...email merge gives lost h-links
We have an access db containing email addresses and a
word letter containing instructions and hyperlinks. When
we do an email merge, the hyperlinks become disabled in
the resulting email. When we merge the letter as an
attachment, the links are available using CTRL-click.
Is there a setting in security on client or our part that
causes this to happen? How can we send live links?
...cross linking excel files
ok, there is a nut that i cant break.
I have 2-3 excel files that need to be linked.
File M (master) contains multiple worksheets, of all sorts of data, its
the master file for my files
File L, is a lookup file im creating for better usage, its used for
dumping data from msproject and reformat some stuff. It has only one
sheet of relevance.
File S, the summary file is the thing i need help with, it is linked to
both files and is used to create monthly summarys. In that file i am
using a lot SUMIF elements like:
SUMIF ([file M]sheet1!A1:A30;B8;[file M]sheet1!D1:D30)
Now the thing is: Th...Select all entry data from two linked (with a relationship) Tables
I have two tables that are liked with a relationship:
"Orders" and "Reports" with the OrderNumber column.
Orders Table (PK -> OrderNumber):
Reports Table (PK -> ID):
ID OrderNumber HoursWorked
4 123456 5
5 123456 4
6 876433 17
What would be the SQL SELECT command if I have the "ID" of a Report, and I
would like to get the "HoursForOrder" at the same time with a single command?
Since they are already linked I am wondering if should I really need to
execute t...Exchange 2003
I'm stumped and I only have 1/2 of the puzzle. Our organization is
signing up to begin an epaystubs service for our employees. The
company that provides this service has asked us for our exchange
server IP, email address for the service account, and a username/
for the account.
I have setup a service email account for notifications with a username
and password. I gave this information to the company that is
providing the service. However, it will not work.
They house the software on their server and use the email account and
credentials that I set up for the service account ...Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to
SQL 2000) to ASP.NET(using store procedure in SQL 2000).
Finally, I tested them and found that ASP.NET is slower than Access.
The mojority job of program is select some data from SQL 2000 tables, modify
and then insert into some tables.
Is store procedure always fast than Access linked table via ODBC?
Message posted via http://www.sqlmonster.com
Stored procedures don’t add any overhead and they can save compile time.
It's the code in the stored procedure and the underlying tables / indexes
that ...sync issues folder
hi, i am traing to remove from my outlook 2003 the sync issues folder.
(i know it is on the server) how can i do that ?
i used one time the cash mode but not any more.
Try OWA. If that doesn't work, you could try an Exchange 4.0 or 5.0 client,
if you can find a copy.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"hlitvak" <email@example.com> wrote in message
> hi, i am traing to remove from my outlook 2003 the sync issues folder.
...How to code macro to import web link and avoid frame within HTML?
Does anyone have any suggestions on how to import web link into Excel and
avoid frame on web page?
When I browse following link, it look fine on IE, but when I insert this
link into excel, it shows nothing, because of frame within HTML.
Does anyone have any suggestions on how to solve it within Excel?
Thanks in advance for any suggestions
...SBS 2003 STD SP2 Exchange not receiving external messages
I've read many posts oncerning this problem but have been unable to make it
work for me.
1. I have a small business acct with AT&T with port 25 open; 2. I'm able to
send/receive internally and send externally; 3. DNS is hosted at ZoneEdit
with a MX record (mail.ghttech.com) and A record (mail.ghttech.com); I can
telnet (ghttech.com 25) from an external source and get a valid response; 4.
When I send a e-mail message to an internal address I do not get a NDR
kicking back to troubleshoot; 5. I have 2 NiCS configured (internal Private
IP), (External Plugged into Rou...Link name of the sheet to a cell.
Hi all, I am trying to link the name of the sheet (in the tab at the
bottom of the workbook) so it appears in a cell.
Message posted from http://www.ExcelForum.com
Try one of the following formulas (note: the workbook has to be saved before
File path and file name:
File path only
File name only
=MID(CELL("filename",A1),FIND("[",CEL...Updating external references
How would you solve the following problem:
I have a few houndreds of .xls files on a certain computer in the net,
many of them having links in formulas to external .xls files. They now
all should move to a different folder. This means the links are not
valid anymore. I have to find all .xls files and update the links. How
could I do that?
best regards, tequilajoe
...Unable to install Exchange 2003 (5.5 migration, LDAP/DS issues)
The overall goal is a NT 4.0 migration to 2003�along with the
migration the Exchange 5.5 server to Exchange 2003. Since we
do an in-place upgrade from Exchange 5.5 to 2003, we need to install
Exchange 2003 on an interim (3rd) server�.then temporarily move
the mailboxes, public folders, DLs, etc�to that Exchange 2003
server. Following that, we'll rebuild the Exchange 5.5 server as
Windows 2003 server and install Exchange 2003 and then move all data
back to it.
The issue is that we are unable to install Exchange 2003 on the
interim server. There is appar...