need a product key after downloading Can't find it
Why such a complicated way to download a Microsoft office free trial. Can't
use it as I can't find the product key. This is just not necessary. How much
time do I have to spend on this to be able to use the free trial download? If
you tell me to follow the suggestions, I have, but can't find the source.
Trial product key displayed on the page from which you download trial
Project. Follow the lnk
http://office.microsoft.com/en-us/project/HA101672711033.aspx and download
software once again. On the last step before actual downloading you will see
the ...Splitting Linked Files
I have 3 files used for materials management. They each contain data
crosslinked from file to file. The files have become quite large and editing
each is being impaired due to the size of the files.
Will splitting the files into several smaller files improve performance? The
links would still remain but each file would have a maximum of 25 or so
worksheets nstead of the 200 currently in the largest of the 3. Any input is
Like a duck on a pond, stay calm on top and paddle like hell underneath.
...Linking two documents so they open simultaneously
How do I link two documents so that one of them opens up when the other is
openned? For example, I am working on a main document and there is a
reference list that I stored as a different document. Is there a way to link
the two so that when I open the main document, the reference document will
automatically open? Thnx
In your main document, you can insert a link to the reference list. Assuming
that you are using Word 2007, here's how to do that: Place the insertion
point at the appropriate location. On the Insert tab, click the arrow next
to Object, and then click Text fro...Does any one know how to globally remove links in an excel spread.
Here's one way: http://j-walk.com/ss/excel/usertips/tip031.htm
Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.
With this add-in you can find and delete links if any exist.
Gord Dibben Excel MVP
On Wed, 19 Jan 2005 12:21:03 -0800, EAsham <EAsham@discussions.microsoft.com>
...Linked header and footer file/image
I am trying to find a way to link all of our publisher documents to
stored header & footer images or files. I surpose this is a dynamic document.
e.g. If I want to change a telephone number on the footer, I would edit one
file, and this would replicate across all documents (much the same way a
website is designed).
We have recently changed the footer on our documents, saved and printed to
..pdf. Then I have had to make a small change to the footer, which is very
time consuming to go through the many files we have. I would like to
implement dynamic documents so our header...links
hi i was wondering if anyone could help.
when i sign into messenger i click on my inbox but the window will not open
it just says connecting all the time.no error msg comes up.
i also have this problem connecting to ebay through the nectar rewards site,
very frustrating as i can collect points
thanks in advance
On Mon, 3 Dec 2007 14:31:01 -0800, madcow <firstname.lastname@example.org>
>hi i was wondering if anyone could help.
>when i sign into messenger i click on my inbox but the window will not open
>it just says connecting all the time.no error msg come...Find a link to an external file
I'm working on a excel file constructed bij a person that doesn't work
here any more. The problem with this excelfile is that there is a link
to an external file wich excel can't find.
I already tried to search for the filename he asks for in the equations
and cels. But it doesnt result in any hits.
How can I find this link so I can remove/change this cel.
Does anyone has an idea?
Tadashii's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=239...ExOleDB Permissions problem as linked server
I have Exchange 2000 server and SQL Server 2000 installed on the same
box. I using the ExOLEDB data provider to set up Exchange as a linked
server in SQL Server. A public folder is queried in a stored procedure
using OpenQuery and a SQL Query against the Exchange folder.
This all works fine, as long as the user is an administrator. If a
non-admin attempts to use the stored procedure, the SQL Server returns
the error "Could not create an instance of OLE DB provider
'exoledb.DataSource.1'.". I know that it can (as I can do it as
admin), so it appears to be a permissions proble...Pop-Up Subform not linking to Main Form
I have a subform - frmLawEnforcement - that is accessed on the main form -
frmCorporateSecurity - by clicking on a command button from the main form.
The two forms are linked by the CaseIDNumber field.
If I place the subform as just an entry from with the main form, the
information shows as linking by the CaseIDNumber. When I enter the
information into the subform using the command button, the information does
not link to the case number.
I am not sure what I could be doing wrong. I am an intermediate Access user
but am fairly limited on VBA.
It would help...Refresh external data message
I have a workbook that comprises of 2 worksheet, wk1 and
wk2. Wk1 has detail information which feeds into a pivot
table in wk2. I have one macro attached to the activate
event on wk2 to refresh the pivot table.
However, every time I open the workbook I get a message
saying "This workbook contains queries to external data
that refresh automatically......" "Enable automatic
refresh" or "Disable automatic refresh".
To the best of my knowledge I don't have any queries or
links...can anyone tell me why this message is coming up
and how to get rid of i...find item in coloumn
I want to find a whole string in coulumn b
how do I do that?
Set c = ws.Cells.Find(ename, Null, Null, xlWhole) '
Set c = ws.Cells.Find(ename, "B3", Null, xlWhole) '
these fails totally
The help does not explain anything
The macro recorder can be your friend
' Macro7 Macro
' Macro recorded 3/23/2010 by Donald B. Guillett
Selection.find(What:="Person2", After:=ActiveCell, LookIn:=xlValues, _
Loo...Setting Cell Links in Forms
I am creating a spreadsheet with multiple check boxes and drop-downs, and wonder whether there is a way to globally set the forms to link to the cells which they populate - if the checkbox is in cell "G21", can I associate the value to cell G21 without manually going to the Format Control dialogue box? Doing so manually for each item is very (!) painful and time- consuming!
If you're very careful with the placement, you could use a macro that assigns
the linked cells:
Dim myCBX As CheckBox
Dim myDD As DropD...editing while using "find"
After upgrading to XL2000 I can no longer edit cells
without first closing the find window.
You sure you didn't downgrade?
xl2002 was the first version that had this ability.
But you may want to try Jan Karel Pieterse's FlexFind:
> After upgrading to XL2000 I can no longer edit cells
> without first closing the find window.
...Link from an Excel spreadsheet to a specific slide in PowerPoint
I can easily link from Excel to a PowerPoint file, but how can I make it go
to a specific slide within that file/presentation?
Charlie in Virginia Beach
Since PPt doesn't support bookmarks like Word, I doubt that you can. Perhaps
another aproach, like saving a copy of the presentation as a Web file might
get it done? |:>)
"VAB Charlie" wrote:
> I can easily link from Excel to a PowerPoint file, but how can I make it go
> to a specific slide within that file/presentation?
> Charlie in Virginia Beach
...where can I find a simple home budget work sheet?
I want to record all our home expenses on a daily basis to keep track of
where the money is going. I am looking for a worksheet to accomplish this in
a simple way.
"Jagadeep" <Jagadeep@discussions.microsoft.com> wrote in message
> I want to record all our home expenses on a daily basis to keep track of
> where the money is going. I am looking for a worksheet to accomplish this
> a simple way.
> Thank you.
Try Office Online - plenty of Home Budget templates there. In f...Where is the option in Windows Server Backup to add/remove external backup disks??
I'm running Windows Server Backup on my 2008 server. Everything works
fine however I can't find the options for adding/removing a drive from
the rotation schedule.
For example say if I wanted to add a third external drive to the
rotation schedule where are the options for this?
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
SBS2003 SBS2008 Support - www.SBITS.Biz
Question or Second Opinion - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.co...Business Portal 2.5 -- Linking 3 Web Parts
Can someone tell me if this is possible, I have been working on it and can't
seem to get it to fly.
I have my 1st web part that shows inventory master item information and a
few fields off of the item card. This drives a 2nd web part that shows
summary inventory information on that item by site. This works fine.
What I want to do is tie a 3rd web part in that gives me detailed
transaction information for that particular site (the 2nd web part). This
3rd web part works fine on it's own but shows all transactions for all sites
for all items by default. I have tried ...external data range a two way street?
I've sucessfully set up an external data range in excel that points to an
access database query. It refreshes with no problem when making changes in
However I would like to be able to update cell values in excel & see the
changes reflected in the Access db. I've tried playing around with the
permissions but no matter what, any changes to data in excel get lost when
the refresh button is hit.
I'm sure I'm missing something . . .
Thanks in advance.
Hi bicyclops --
One way street. An external data range can suck data out of Access, SQL
Server, Oracle, whateve...How can I Copy WLM folders from external to "C" drive
Hard Drive Crashed and is now drive "I" as external. Reinstalled WLM on C
Drive and it connected to my two email accounts, but did not bring all
folders in. I still have a backup of my Outlook Express files from a month
ago (prior to moving to WLM) that I wouldn't mind bringing in to replace the
one email account. I also have a backup of my other email account. What
would be the best way to handle this?
You can go to File (ALT+F), Import Messages from WLM and point to the I
drive folder that contains the old message store. Search for *.EML
files to locate.
Y...import external data from password protected website?
How can I 'harvest' data from an html table when the user has to login to
the website to get to the data? Also, it appears that 'import external
data' just wants to dump the results into a spreadsheet, I want to pick out
specific data and put them into the spreadsheet I've been maintaining. Can
this be done via a macro? If you can point me to an example I'd appreciate
Thanks in Advance,
There is a password field for "get external data".
Record a macro and add the field.
Picking specific data to import depends on the "target m...Macro to find and delete all FALSE statements
So i have a sheet filled with formulas and I have put IF,Then statements in
them to return FALSE is I don't get the result I want. However, I need to
erase all these FALSE results so they do not plot as zero on my chart.
Anyway to create a macro? Thanks.
You may not need a macro.
If you formulas are of the type =IF(A1<10,FALSE,A1), select the range and
use Edit | Replace to change FALSE to NA(). The NA() will show in cell as
#N/A and will be ignored by the chart.
remove CAPS in email address
"Woody13" &l...External messages not coming in
I have an SMTP gateway set to received messages, scan them with Symantec
Brightmail and then send it in to the Exchange server that has the users.
All of a sudden yesterday messages stopped coming in. The outgoing messages
are working fine. The SMTP server is a Windows 2003 enterprise and the
Exchange server that catches the messages is a 5.5 server. I found an
article on Microsoft Website regarding 8bitmime and I fixed that but it still
does not work. Anyone has any suggestion. Thank you.
On Tue, 9 Aug 2005 13:07:02 -0700, "h gregorian"
In this web app I’m working on there is this place that logs some information
about Thread.CurrentThread. This logging is supposed to only happen on
threads that the application spawns. The application assigns
Thread.CurrentThread.Name a name and then later logs that name into a SQL
But sometimes when we log the thread’s name it isn’t our assigned name.
Instead it is “Thread-1” all the way up to “Thread-26”. By default
Thread.CurrentThread.Name is null so we can’t figure out where these other
threads are coming from. We can only reproduce this problem on a web se...Linking then Sorting Objects of the Link
I am wondering if what I want to do is logical. (Excel 2002)
I have a workbook with two worksheets. One of the sheets has a link to a row
in the other. I created the link using right-click, then selecting
"Hyperlink" and designating a defined name as the destination. (I designated
the entire row as a defined name)
Problem is, when I sort the latter sheet, the link still points to the
defined name location, it does not seem to know to stay with the row that has
the defined name I designated as the object of my link when it moves because
of a sort. If I cut the row and paste it ...Linking to Graphics
Is there a way in Excel 2003 to link column text to a .jpg photograph o
my computer? I have to track inventory and would like to be able to se
the object in question. If not, what options are available. I am ne
to 2003 and have only used 97. Thanks
scw1217's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281
View this thread: http://www.excelforum.com/showthread.php?threadid=49770
Maybe you could just hyperlink to that file.