|
|
Excel hyperlink problem by
Spork Rhonewood
I had the same problem and here's my solution. It apprears that when
ever you save an excel speradsheet to a network drive it changes all
the hyperlink...
|
|
0 |
374 |
|
|
Automatic Calculations by
Berend Botje
Hi,
For some reason the calculations made in my Excel documents require a
manual action, instead of being executed automatically.
I have tried switching to...
|
|
3 |
285 |
|
|
automatic macros by
itsme
I have a macro in one of my sheets of a 9 sheet file (run by ctrl z). Is there anyway to have it run automatically when I first open the file. If so,...
( 1 2 3)
|
June 16th, 2004 02:58 PM
by itsme
|
25 |
751 |
|
|
|
June 16th, 2004 03:00 PM
by AlfD
|
3 |
605 |
|
|
|
|
1 |
171 |
|
|
Selecting or deleting data by
Joey
Hi all
Is it possible to have a formula which recognises whether to select or
delete data.
Eg;
A1 = xxx
A2 = yyy
A3 = zzz
|
|
5 |
217 |
|
|
File Not Found by
Salvatore Iannazzo
I have Excel 2000, and I use Paste Links often. Sometimes
one of my files seems to get "infected" in such a way that
when I open it, I get a "File Not Found"...
|
|
1 |
309 |
|
|
running a macro only if criteria are met by
The Grinch
hello all,
I have a macro that runs fine, the problem is it relies on user input,
and will run even if the data received is invalid. I can calculate
simple...
|
|
2 |
325 |
|
|
Automatic Cell Re-sizing by
Tappie
I have created a spreadsheet that is to be completed by
several people.
Some of the cells in the spreadsheet are protected appart
rom the ones to be completed...
|
|
1 |
150 |
|
|
Row and column Headers formating by
Salim
When I open a particular workbook i always find the
headers are strikethrough, I need a help on how to remove
this strikethrough, note this is not on the cells...
|
|
2 |
198 |
|
|
|
|
3 |
417 |
|
|
Read Only Folder by
cwt
I would like to create a 'Read Only Folder' or
a 'Password Protected Folder' in which I can add
spreadsheets to without having to individually protect
each...
|
|
1 |
164 |
|
|
Not sure what type of formula is needed by
shternm
I am looking for a formula that's going to look at column where there
are multiple text entries and return a list of all distict entries.
For example,
Column...
|
|
2 |
429 |
|
|
Check Box Sizing by
beantownbrad
Hi,
When using check boxes, no matter how much I resize the area, the actual check box itself never gets larger (only the area for a description does). Is...
|
|
1 |
378 |
|
|
Number of pages in a document by
saybut
Hi,
Could anyone tell me if it is possible for excel to return information
about a document in a folder?
I have several pdf's in a folder on my c: drive. Is...
|
June 16th, 2004 05:19 PM
by saybut
|
0 |
480 |
|
|
Calculate Due Dates in slabs by
Shanks
I have 3 dates within a month to make cheques,as per
Bills received. Below is the matrix for the same.
Received Paid on
23rd to 5th ...
|
June 16th, 2004 05:33 PM
by jeff
|
1 |
321 |
|
|
not enough quota by
Mike P.
I am running Excel 2000 on Windows 2000. I have created a
small spreadsheet (25.5 kb)with several hyperlinks. When
I try to save it to the network share I...
|
June 16th, 2004 05:37 PM
by jeff
|
1 |
330 |
|
|
|
|
5 |
694 |
|
|
|
|
0 |
581 |
|
|
Setting up hot key by
George A. Yorks
Setting up excel spread sheet want to be able to hot key
from any cell back to a given cell. ie: from g15 back to
a3.
Any help appreciated
|
June 16th, 2004 06:27 PM
by AlfD
|
1 |
182 |