|
|
Linking Pivot Tables to Access Queries by
Nigel
I have developed several Pivot Tables, in Excel, which use a live link to an
Access Query. I am updating these queries to make them more comprehensive,
across...
|
|
1 |
167 |
|
|
sorting links by
Branko
Please, someone have a macro for sorting hyperlinks?
When I sort a selected area with hyperlinks the resulting hyperlinks are
disabled or mixed-up.
I can send...
|
April 7th, 2005 03:03 PM
by Branko
|
4 |
239 |
|
|
tooltip text by
Duraiswamy Lingappan
Hi,
I have added button inside excel sheet(not vb control). Is it possible to
add tooltip text for this?
I am able to set tooltip text for vb controls. But i...
|
|
1 |
192 |
|
|
New to Linking by
tinkertron
Another employee and myself find that our bosses are giving us more and
more work that revolve around the same information that we enter into
several forms,...
|
April 6th, 2005 03:57 PM
by JulieD
|
1 |
213 |
|
|
|
April 5th, 2005 09:25 PM
by nathan
|
0 |
150 |
|
|
Link between workbooks by
Dan
i have 2 excel workbooks that i have been using for the
past year or so and now we upgraded from windows 2000
operating system to windows xp. The problem...
|
April 5th, 2005 02:51 PM
by Dan
|
0 |
152 |
|
|
multiple cell references by
Branko
If I have in a cell reference
=SUM(A3:A300)
how to have 3 and 300 referenced to another cell so that I can change range
without changing formula?
|
|
5 |
270 |
|
|
|
April 3rd, 2005 08:09 PM
by Branko
|
4 |
288 |
|
|
|
April 2nd, 2005 10:02 PM
by Rich
|
3 |
1,519 |
|
|
|
|
3 |
512 |
|
|
linked workbooks in different folders... by
Mark Scholl
Here's my situation:
I have a group of folders that is routinely copied to an alternate
location. There are excel files contained within; some of them in...
|
|
1 |
239 |
|
|
Saving in html by
Peco Worker
I have an excel spreadsheet that I hyperlinked on an intranet site. There
are multiple users who need to change the spreadsheet on a daily basis. When
they...
|
|
1 |
150 |
|
|
|
|
4 |
148 |
|
|
Linking Multiple cells by
bwhadden
Lets try this again,
I have a work sheet that I will replace data in on a daily basis. I will have one column that has a list of values that doesn't change,...
|
|
1 |
529 |
|
|
Hyperlinks change after sorting by
Hyperlinks change after sorting
Hello!
I have my movie database in Excel. When I sort a table by a column that
contains a web link to a Director the sorted table has half links disabled...
|
|
0 |
111 |
|
|
Poll:
Why can't I edit my external data sources? by
jcoburn
I have just upgraded to Office 2003. I find that I can no longer edit external data sources used in some of my Excel workbooks.
It opens the msquery program,...
|
March 29th, 2005 04:40 PM
by jcoburn
|
2 |
197 |
|
|
create linked autofiltered sheets? by
wembley
Hopefully there is an easy answer to this for a non macro type person like
myself:
I have a master sheet that I can either autofilter or use the excel...
|
March 26th, 2005 04:37 AM
by wembley
|
0 |
130 |
|
|
How to control the area? by
Allan
I have a small Excel spreadsheet that I am trying to insert as an object in
a Word document. The spreadsheet is about 10 columns wide x 30 rows high.
When I...
|
March 25th, 2005 05:39 PM
by Allan
|
2 |
145 |
|
|
|
March 25th, 2005 03:31 PM
by JulieD
|
5 |
214 |
|
|
|
|
1 |
157 |