Turn off looking for linked spreadsheets
DHeacock wrote on May 26, 2005 10:44 EST |
I frequently open sheets sent to me from our field office that have multiple links to sheets located there only.
I must click on the box seeking these sheets several times for each spreadsheet that I open. I would like this turned off.
How do I do it? |
Text to columns
DHeacock wrote on May 26, 2005 10:47 EST |
I download data from a DB into excel and then convert text to columns.
Some of the well data goes into the proper columns but most don't and usually inserts unwanted columns (in the middle of data) that I have to manually remove.
Since I do this every day, can I control the columns so all the wells make the columns properly? |
Reply: DHeacock
Alan wrote on May 29, 2005 23:57 EST |
Hi DHeacock,
[QUOTE=DHeacock]I frequently open sheets sent to me from our field office that have multiple links to sheets located there only.
I must click on the box seeking these sheets several times for each spreadsheet that I open. I would like this turned off.
How do I do it?[/QUOTE]You should only get that message once upon opening each workbook, but you say that it is happening multiple times for each one?
You could use code to open them without updating links, but to be honest, I find it hard to believe that it is worth the effort - easier just to press 'N' each time you open a workbook.
HTH, but if not, post back and we'll help with the code option, but I seriously doubt the effort is worthwhile for you,
Alan. |
Reply: DHeacock
Alan wrote on May 29, 2005 23:59 EST |
Hi DHeacock,
[QUOTE=DHeacock]I download data from a DB into excel and then convert text to columns.
Some of the well data goes into the proper columns but most don't and usually inserts unwanted columns (in the middle of data) that I have to manually remove.
Since I do this every day, can I control the columns so all the wells make the columns properly?[/QUOTE]How are you downloading the data? Are you using MS Query? Also what do you mean by 'wells'?
Thanks,
Alan. |
AMAZING FORMULA
MAJID JALALI wrote on June 03, 2005 03:55 EST |
Really exciltip.com is one the best websit in application software this is GOD GIFT FOR ME and I m thankfull my
God .......................... |
Duplicate Entries
Victoria wrote on December 31, 1969 19:00 EST |
Hi. I use excel to hold lists of phone numbers for telemarketing. I'm currently using the semi-manual way of CTRL F to find duplicate numbers.
I've been told that there is a formula you can set up that will detect and highlight duplicate entries within a specified column. I was wondering what is the formula, and how do i set it up?
Thanks
Victoria |
New Records Entry indentification?
BHARATHBOSS wrote on June 22, 2006 10:33 EST |
Hi,
Please help me with the problem.
I get a list of new records everyday in the morning.
that gets updated automatically from the last saved record.
How do i identify the fresh record set
thanks
bharath |
SSP wrote on December 31, 1969 19:00 EST |
In exceltip.com i found many solution of my problems
Thanx excel tip...
Regard
SS Patel
|
Locate and Mark Duplicate Entry
Tom Read wrote on December 31, 1969 19:00 EST |
| I have a list of business names with duplicate business names within the list. I would like to instruct excel to identify those listings which are the same as another without any prompting of what to look for. For example if BHP PTY LTD appears on line A200 and also on A5078 I would like to make those duplicates with true, duplicate or some other refference. |
duplicate values
jciii_uy wrote on February 08, 2007 11:08 EST |
Columns A:B contain two lists of values.
How could we create a formula that will check whether each of the lists contains duplicate values (disregarding blanks)?
My Question is...
After determining that there are duplicates, can we make a colorcoding of the items found to be duplicate especially if we are talking of voluminous items?
thank you and best regards.
sincerely,
jC
EXCELTIPS is the best.... |
oldchippy wrote on February 09, 2007 17:53 EST |
Take a look at this link, it may help
[url]http://www.j-walk.com/ss/excel/usertips/tip073.htm[/url] |
Yes, You Can Time the Market!
