|
Changing source on multiple workbooks
We have one main workbook that the supervisor fills out that lists jobs,
times staff etc. I've just set up links to the daily worksheet workbooks
that automatically fill in which staff member is doing which jobs each
day.
But the problem is, the supervisor makes a copy and changes the name of
the main workbook weekly so that the sources for the other 7 workbooks
are now wrong.
I've shown ...
|
2 |
26.01.2006 21:08:44 |
|
|
Workbook with phantom link
When I open the workbook excel asks if I want to update links to other
workbooks.
There are no links, I have searched all the worksheets in an effort to
delete them but cannot find any.
Does anyone have a suggestion? When I go to properties excel shows me the
link and the name of the worksheet the link refers to. I select all the
worksheets and do a search for the link but cannot fi...
|
4 |
23.01.2006 22:08:59 |
|
|
How can i make link to different sheet
Dear all.
i have 5 excell sheet,
1 - work unit rate employee list
2 - time unit rate employee list
3 - schedule employee list
4 - Aramco employee list
5 - All employees list ( work unit + time unit + Aramco unit + Schedule
)
My quetion.
1. I would like to make link all sheet. How can i do it?
2. when i add new emplyee records, it should go to relative unit
sheet.
So please help m...
|
1 |
22.01.2006 05:48:54 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:23:25 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:23:20 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 15:45:07 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 15:45:00 |
|
|
Hyperlink to Outlook Public Folders
I am running Office 2000. I have created a hyperlink from Excel to a specific
public folder in Outlook using the link:-
Outlook://Public Folders/All Public Folders/Foldername
The link works but opens another copy of Outlook in a separate window. I
want the link to go to the copy of Outlook that I already have open.
If I put the <> symbols at either end of the link as recommended...
|
1 |
18.01.2006 10:37:02 |
|
|
Free mp3's
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>And much more that that!</P>
<P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P>
<P>This site offers free and legal mp3's, software, movies, games.<BR>They also
have a l...
|
1 |
18.01.2006 02:31:51 |
|
|
Linking Excell values to word document
Hope this is the right group - I found nothing suitable for microsoft word.
I have a word document with embedded excel sheets that link to a master
excel file. When I change values in the master excel file I want to be able
to open the word document and print with all the new values calculated but
it does not update unless I open each embedded sheet in turn befor printing.
How can I get ...
|
1 |
17.01.2006 20:56:34 |
|
|
Prevent error messagebox when refresing querytable from the web fails
Hi,
I have an excel workbook with a querytable on a sheet
The querytable retrieve data from a web site, and I need that data to
be checked automatically, and saved when some data is changed.
So I create a class to implement QueryTable events, and I have my own
code in AfterRefresh, which saves changed data
I need this to be checked and saved automatically, regardless if I'm in
from of P...
|
14 |
17.01.2006 13:24:48 |
|
|
Pop-up windows upon save &/or close
Okay....I have a worksheet with 93 tabs, and I'd like a pop-up message box to
display when a user attempts to close, print, or save the file, but only if
two cells do not contain the same figure. For example, if cell a5=5000 and
cell a6=6000, I need a message to display stating that the cells must contain
the same number. Is there a way to write the code without creating a macro
for it? I kno...
|
2 |
15.01.2006 19:08:39 |
|
|
Exporting data in Excel permanently to Access
How do I export a range of data which is in a row/column format (i.e.,
row=record, column=field) in Sheet3 to a file that can then be easily
imported to an Access table?
Please point me in the right direction on the best way to do this. Thanks
FURTHER DESCRIPTION OF MY CURRENT SITUATION:
I have an Excel file that my field techs enter data and print customer
reports from. The file co...
|
2 |
12.01.2006 03:56:02 |
|
|
How to update ORACLE query definition in Excel file
I have an excel file with several queries.
This is connection string.
It is saved in Excel file UID and PWD.
I can see it using this macros.
http://support.microsoft.com/kb/330383/en-us
Connection --> ODBC;DRIVER={Oracle73 Ver
2.5};UID=MYNAME;PWD=MYPASS;DBQ=PROD;ASY=OFF;
CommandText --> SELECT USERS.NAME FROM SCHEMA1.USERS
How to update CommandText SCHEMA1 with SCHEMA2 in abo...
|
1 |
06.01.2006 14:56:02 |
|
|
Variable Links to Tabsheets
Hi!
How can I make a link to another sheet be dependable on one cell value
(without ifs)?
I give you an example:
I have a worksheet with three sheets ('Sheet1','Sheet2', and 'Sheet3')
In 'Sheet1' I have two cells:
A1 - Its value can be 'Sheet2' or 'Sheet3'
A2 - It has a formula (for example: 'Sheet2'!B1)
I would like to make a formula like this one for cell A2: *A1*!B1
and the ...
|
4 |
06.01.2006 01:01:39 |
|
|
accessing & breaking links
I have templates which contain a data entry sheet linked to multiple
calculation & results sheets. The tech enters data for each unit into the
data sheet, views, prints & individually saves each unit's results sheet. I
need to break the links between the saved copy & data sheet.
Here are my problems:
I can't access the links dialog box from the linked sheets in the template.
If I coul...
|
2 |
04.01.2006 22:34:02 |
|
|
linking excel to outlook
i need to set up a link from an exchange server to an xl workbook which will
be updated manually and record only certain parts of the email activity (to,
from, subjetc, date & time sent)....
|
1 |
04.01.2006 10:24:04 |
|
|
Creating links in work book
I would like to Link cells to worksheet so that when entering data in one
cell the other cells will have the same data inputted automatically.
For instance, I have three worksheets, ws1, ws2, and ws3. In each of the
worksheets there are several cells that contain the same data. I would like
to link the cells so that if I go in anyone of the worksheets to update the
data, the other work...
|
2 |
03.01.2006 21:18:24 |
|
|
Showing URl of link?
Hello - Newbie question:
I have an Excel file (98) with 1600 names of people
Each name is a link to their personal file
I need to know how many of the links point to the 'under construction' page
Is there a way to automatically show the URL's so that I can count how many new
personal files we need to create ?
I can only seem to show them one at a time :~((
TIA, Jenny
--
Jenny
(Ro...
|
2 |
03.01.2006 19:42:30 |
|
|
Linking to a pivot table from a formatted invoice
Hi people,
I have a workbook that is organized as follows:
First sheet: "Raw Data"
A series of timesheet entries, showing worker, date, number of hours worked,
and a job number. Row 1 is a header row, rows 2 through 499 are data rows,
and row 500 is for totals. This sheet has a lot of individual lines of data,
with many instances of any given job number, each with one or more
associ...
|
2 |
01.01.2006 22:02:06 |
|
|
Linking Large Access Table into Excel
This is something I have never done, but an curious on how it would work. I
have been looking around here and on Google, but haven't quite found what I
am looking for. To be upfront my preference would be to just keep this
entire system I am going to discuss in Access, but NO ONE at my work besides
me knows how to use Access. So we end up with 50MB & 30MB Excel files that
contain one...
|
2 |
30.12.2005 23:28:41 |
|
|
Earn money Online - without risk!
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary?
Then you should take yourself a couple minutes time. You happily will be
that you ...
|
1 |
25.12.2005 01:56:36 |
|
|
THE > SUPER-MONEY-SOURCE <
THE > SUPER-MONEY-SOURCE <
Would store / would copy this text or side before the administrator could
remove this letter.
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER-MONEY-SOURCE <
In this program, there is really money.
1200.- Euro ...
|
1 |
22.12.2005 22:51:40 |
|
|
Linking and errors
Hi All,
I have sixty odd spreadsheets (one for each staff member) that contain a lot
of data spreadout over a number of tabs and cells.
I have a single spreadsheet with sixty odd tabs that links all the data i
require in a tidy format, however i have some problems.
1. A number of the linked cells after updating have #N/A in them, this is
usually but not exclusively in the top sev...
|
1 |
21.12.2005 10:52:02 |
|
|
Importing Microsoft query data into excel changes linked rows
I have a data-range that I import into excel from SQL tables. The problem is
that each time new records are added to the data and imported into excel, the
links I set to grab the data change and I dont want them to. Basically I
have a large row of data. Say from 1 - 100 and it is linked to another
datarange from 1 -100, but when the data-range updates, the sequential order
of the link...
|
2 |
19.12.2005 09:09:25 |