Disable COPY function
Does anyone know how can I avoid/restrict people Copying-n-
pasting data from my excel spread-sheet. I am trying to
lock down an excel spread-sheet to "Read Only" - in its
true sense and dis-allow even copying data from this sheet
to any other. Basically I want to turn off the COPY
Secondly, if a person saves this sheet locally under
another file name, how would I still disallow the COPY
function. Is there any VBA module (which I can later
password protect) which takes care of this. I do not have
admin rights to set folder/file server permissions and the
hiararch...Excel 2000 problem #2
I have a problem on a file that was recived via e-mail, when i try to open it
on excel 2000 it gives me the following error "The workbook you opened
contains automatic links to information on another workbook, do you want to
update this workbook to changes made to the other workbook" it then gives me
the option to ""update all linked information" or to "keep the existing
Chose the option to keep the existing information.
That will have the data at the time the file was sent to you.
If you need to have the information updated, you will need t...Calculating turaround time using IF function
I'm just learning to use the IF function, and it is not calculating
correctly, so am looking for help. I'm using Excel 2000.
For my spreadsheet, if a document is made available after 1700 hours
or before 0700 hours the following day, I want it to calculate the
turnaround time for those reports to begin at 0700 hours; otherwise
calculate the remainder of the reports from the time the report became
available to completion. Here's the IF statement I'm attempting to
use with little success.
E=Time report available
Searching in excel
What is the best program or way to search in excel? (other than using
simple find) I'd like to be able to see all of the results in one area
and then click on to jump to it. Is there anything out there that has
search function that is smarter than "find." Like a "google" typ
search. I need to be able to search multiple sheets at once.
Message posted from http://www.ExcelForum.com
xl2002 added an option to find in workbook.
in xl2k, you could group your worksheets and do edit|find.
But in all versions, you can use Jan Karel Pieterse&...excel trying to add rows +col
am trying to add rows and clumnes of fig for end of year accounts,
am clicking sum, highlighting the row hit return then nothing am i missing
Try selecting (highlighting) and then click the auto sum icon
"mowerman" <email@example.com> wrote in message
> am trying to add rows and clumnes of fig for end of year accounts,
> am clicking sum, highlighting the row hit return then nothing am i missing
> some thing
...How to call a non static function from a static function
I need to go to a non static function from a static function?can
anybody suggest me how to do it?any kind of help will be greatly
You need to pass the object whose function you want to call.
static void s_foo( A* a );
static void s_foo( A* a )
...Embedded excel worksheets in word
Since Office v. X I have been unable to embed excel worksheets in word that
contain more than five columns. Can anyone tell me that I have been doing
something wrong OR tell me if 2004 fixes this problem?
in article BCD52774.75C7firstname.lastname@example.org, Mike McGetrick at
email@example.com wrote on 22/05/04 21:51:
> Since Office v. X I have been unable to embed excel worksheets in word that
> contain more than five columns. Can anyone tell me that I have been doing
> something wrong OR tell me if 2004 fixes this problem?
A...Importing web data to Excel 2003
I have built a flight planning program for aviation using Excel 2003. I am
trying to find a function to import winds aloft from NavCanada's aviation
weather site, to avoid manual entries. Is there a web site where raw text
data from NavCanada's site to import, or a way to import it from their normal
Below there is a link to NavCanada's normal display of data.
Any help would be appreciated.
I get an access denied on your URL................no permission.
But have you tried Dat...Why Excel 2007 not responding after saving
I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now
having problems even opening files. If I click on a cell it pauses for ages
and then says it is not responding.
Try looking for help here:
> I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now
> having problems even opening files. If I click on a cell it pauses for ages
> and then says it is not responding.
...Importing from Excel
Hello, does Money have the ability to create invoices by
importing from Excel? I don't think it does, perhaps I
am missing something. Thanks in advance!
...querying excel spreadsheets like database
I'm making a payroll journal, it has a column for the names, and the
the cheque amt, cheque no., and some other stuff.
In a separate sheet I need to pull up individual information pe
employee and total.
Name: cheque amt: cheque no: date:
jane doe 2000.00 0001 01/01/01
john doe 1500.00 0002 01/01/01
jane doe 1800.00 0003 15/01/01
Name: cheque amt: cheque no: date:
jane doe 2000.00 0001 0...How to work with CSV files in Excel without warnings?
We work with a lot of CSV files in Excel and would like to turn off
the warning that the file "may contain features that are
Is it possible to allow saving a CSV file without warnings?
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.
You could use a macro:
Dim myFName As String
myFName = Application.GetSaveA...Excel Cell Autocomplete
Is there any function, so we can use auto complete while entering
similar entry in to cell, which saves lot's time when entering similar
DEFAULT AUTO COMPLETE WORKS VERY LIMITED, WILL NOT WORK IF SEQUENCE
WILL BREAK, ALSO FOR NUMBERS (A/C) IS NOT WORKING.
I have tried with alt+down arrow, but it's giving entry which below of
that cell...better if we have some thing to lookup which can shows us
all entry in to that column( up & below).
smd111's Profile: http://www.excelforum.com/member...sum function 04-18-10
How can I sum the numbers in a column in Excel where some numbers carry a
"<" sign in front of them (such as <1) and I want to include numbers such
"<1" in calculation as "1".
For Example if numbers are entered as follows
I would like to value to be returned as "2" when I apply "sum" function.
=SUM(IF(LEFT(A2:A4)="<",--RIGHT(A2:A4,LEN(A2:A4)-1),A2:A4)) as an array
formula (Control Shift Enter).
"Vijay Dhawan" <Vijay Dhawan@discussions...excel files will not open
I cannot open my excel files without first opening excel. I have tried going
through properties to make sure it is opening with the right program and it
is. Any other thoughts.
I had a similar problem a while back, had to reinstall office.
pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6261
View this thread: http://www.excelforum.com/showthread.php?threadid=496750
Sometimes one of these works:
Tools|Options|General|Ignore other applications (unch...How do you stop excel from charting empty cells/null values as zer
I'm trying to create several charts from my excel data. Several of the
chart's reference cell (established range) contains formuals. When the
cell's formula returns a null value, chart display's as zero. How do I setup
chart to display null as nothing versus zero?
The workaround for charting calculated cells when you may have missing data
is to use an If formula that selects NA() if there is missing data.
Something like --
= If( d2 = "", NA(), b2*d2)
You'll need to replace your actual cell references and formula.
This formula will place a #N/A in tho...function
The function is as follows:
Purpose: Try to compare a series of numbers, finding out the second smallest
If: The answer is error (ie #NUM!) since there is no number in the row
Then: show nothing (ie "")
Else: show the answer as usual
** Problem **
However this function doesn't work. When there is an error, it will show as
#NUM! instead of nothing (ie "").
How to solve?
- I'm using Office XP
- I'm using Windows XP
=IF(ISERROR(...CRM Functionality does not appear in Outlook
Hope someone can help here - I am a non-technie looking after the
install of CRM for a small sales organisation. I have succesfully
installed the outlook client on all laptops but on 1 desktop I am
getting a problem.
I have installed all pre-requisites and passed all pre-install checks,
and the installation appears to go smoothly. However, the additional
functionality does not appear in outlook.
No error codes are generated so I can't be more specific than this I'm
afraid, any ideas would be greatly appreciated.
in outlook go to tools options..then get t...SumIf Function #3
I'm trying to use the SumIf Function (as I understand its use) and I keep
running into the same problems -- in many cases I have more than one
criterion for addind a specific cell. Is there a way to modify SumIf to
allow for multiple criteria? I try to do it in the insert function box and
it gets spit back out at me. Any ideas?
look at SUMPRODUCT
Look at the Help and search the Archives for examples
"jayceejay" <firstname.lastname@example.org> wrote in message
I can not open excel get dr watson err.
but if I login admin it work.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
See the suggestions at www.cpearson.com/excel/startuperrors.htm ,
specifically the one about removing the customized toolbar file.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"slukas" <...working with excel and other program
We basically feed the data in excel sheet from other application (business
objects) . The data that we enter is purely numbers. however we need to
move up and down between two applications. To move in Business objects i
have to click in the application and then agin to enter that data in excel i
have to click in excel sheet.............we enter huge amout of data and this
is time consuming. could u please let me know if it is possible to move in
both the application without clicking . In other words can we have two
application active at the same time, may be in mouse hover can...Excel graph
How do I create a line graph showing the means and
standard deviations for a series of measures. I would
like the line to connect the mean scores, and have an
error variance bar above & below each mean to show the sd.
...Consistent function of Utilities logon screen when applying hotfix
When our users attempt to install a hotfix roll-up, when they are logging
into Dynamic Utilities for the first time, the user interface is very touchy.
What I mean is that they must click the username field and then type. Then,
they must use the mouse again to click the password field and type. Then,
they must click the OK button. If they try to use backspace, enter key, tab
key, etc., extra characters are inserted. The only way that they can "edit"
their username and password information during logon is to use the mouse to
highlight and the type over the information.
...Conditional Formatting in Excel Help Please.....
Newbie to VBA
I need to use Conditional Formatting to format a range of cells to have
Wheat background and Red text (Bold) if a text string is contained in
each cell. For example, all cells in a range that contain the text
string "LLC" or "Inc" or "Corp" or "Corporation" or
"Company" , etc.
If cell E2 contains Acme, LLC
I need to give that cell (E2) the condition formatting
If cell E3 contains John Brown
That cell does not get the condition formatting
If cell E4 contains Joe's Pool Hall, Inc
Cell E4 gets the condition formatting
Thanks ...IF Function Problem
I am using Office XP and have the following problem
I have a worksheet which uses lookup to extract names from range name
Codes as follows
I wish to add another IF condition to the above formula to test that:
If Col D2 = EGSP AND Col A = date greater than or equal to 15-Nov-2005
then it should display the name as 'Jack' otherwise 'James'.
All other values should remain unchanged
Thanks a lot