I need to know how to make my filter work when my sheet is
protected. My filter works fine as long as my sheet is NOT
protected, but when I protect my sheet, my filter won't
work. Is there any way to make a filter work when the
sheet is protected? I have Excel 2000.
I need help from anybody.
see ans in worksheetfunctions.
"Harold H" <email@example.com> wrote in message
> I need to know how to make my filter work when my sheet is
This is my problem, let say that I got 3 shifts
Colomn A fill with Employer ID_No
Colomn B fill with Date
Colomn C fill with Shift
Colomn D fill with In_Time
Colomn E fill with Out_Time
Colomn F fill with Absen or Present
Colomn G fill with Overtime
Shit I 08:00 AM to 04:00 PM ; normal work hour, next hour will be
Shit II 04:00 PM to 12:00/00.00 AM ; normal work hour, next hour will be
Shit III 00:00 AM to 08:00 AM ; normal work hour, next hour will be
I need the formula to calculate hour in COlomn F & G
thank for any help
We have created a web application that allows users to generate Excel
documents. We use Excel XML to create the document and allow users to open or
save the document. This all works fine. The problem occurs after the created
file has been opened on the users' computer and stays open for a while. Every
now and then Excel crashes. Excel also crashes when the user tries to Save
As.. the document.
Does anyone have any suggestions as to why that occurs.
...How can I delete rows from Pivot Tables in Excel 2000 as in 97
I was able to delete multiple unwanted rows from Excel 97 Pivot Tables.
Now I find I can only delete rows individually by untagging them in Excel
2000 Pivot Table.
This is far too time consuming...
Does anyone have a faster Solution
...Opening Excel spreadsheets via explorer
Hello! I'm hoping the experts here can help me with this quirky
have a user who when she double clicks on a spreadsheet from her My
folder or from an email or such, Excel 2007 opens yet will not open
document itself. If you click around long enough it usually will
open, or if
you go to the open dialog you can open it that way. Here's what I
- under Excel Options/Advanced I've tried both unchecking and checking
option to ignore other applications that use DDE with no luck.
Also have tried modifying how the sheets open using this - Applicatio...Roster / Staff Allocation
Just wondering if on ur travel's if you have come across, a template
that could be used when rostering and allocating staff within either a
retail (Checkout operators) or a aged care facility.
Any assistanced would be greatful.
KingAaron's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37444
View this thread: http://www.excelforum.com/showthread.php?threadid=571114
http://office.microsoft.com/search/redir.aspx?assetid=TC060891341033&QueryID=U...excel save #2
i would like to creat a macro that will save a file automatically when
pressed but without deleting the previous one.
can anyone help
Lins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24223
View this thread: http://www.excelforum.com/showthread.php?threadid=378390
What would you like to happen - always get the Save As dialog? To change
the name of the previously saved version of the workbook? Something
In article <Lins.1qio6c_1118585102.3933@excelforum-nosp...Weird shifting
I have two odd things happening in my document that I don't *think* are
related, but who knows...? I'm using Word 2007 and I have a template that I
created specifically for this document. It is a very convoluted template
based on obsolete military style guides that I have no say in. I have 7
heading levels and each heading level has numbered procedural steps. Each
heading level indents one step from the next higher heading, so by the time I
get to the highest heading level my left indent is about 3". Crazy, but like
I said, I have no say in the format.
Anyhoo... w...Information Source, Excel 2007 versus 2002 Major Differences Dec0
I'm an intermidiate VBA programmer.
I've been developing and addin using excel 2002.
Am going to 2007 soon, and would like to pointed to a source where I can
see what VBA changes, and others, MUST be made.
For example, using Walkenbach's book I search for "help" to insert an app
menu before it, there is no "help" in the excel 2007 main menu.
...Saving Excel 2000 Workbooks as Web Page
I currently have about 1000 excel workbooks that I wish to save as webpages.
Is there any easy way to do this without opening and saving each workbook
If so, any pointers would be greatly appreciated...
Thanks in advance....
...Blank areas near Excel pie charts when printed
I have XP SP3 and Office 2007 and HP LaserJet M3035 printer with PCL6 driver.
When I print a presentation or slide some of the slides with linked Excel
pie charts will make text, borders, etc. that are near it disappear. So far,
the only way I've seen to reproduce the event is to have Office 2007 SP2 and
a PCL driver installed. It can be printed with High Quality and with or
without the various options listed in PowerPoint Options -> Advanced -> Print.
The workarounds I've found are to uninstall Office 2007 SP2 and go back to
SP1 or use the printers PostScript dri...Why does Excel close me out...
Why does Excel close me out after working only 3 sheets?
When I start a new page, it will only allow me up to the
3 default sheets...
Please don't post more than once. Especially after only a few minutes.
Your 19 minutes earlier post was answered.
Gord Dibben Excel MVP
On Tue, 14 Sep 2004 11:02:37 -0700, "Joseph"
>Why does Excel close me out after working only 3 sheets?
>When I start a new page, it will only allow me up to the
>3 default sheets...
Someone tried to help me but I didn't had any results...
I'm working on a two worksheets.
The formula is as follows:
=VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
I want to copy the formula to one cell on the right and turns as follows:
=VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
My problem is that the coll index number does not change...
that means I have to change it manually for 50 collumns.
$A92 is an absolute column, A92 is relative and changes when copi...Excel
I have numbers with 4 leading zeros and want to drop 3 - i've tried custom
0##### but the numbers seem to be formatted so that they won't change. How
can I drop those 3 leading zeros
I would suggest posting in an Excel group where you will find more
people dealing with the program.
I don't know what catagory your question would fall into, but you can
This group for Operating System questions instead of the Application.
On 2010-06-08 15:43, Cheri wrote:
> I have ...Multiple Cell Values, please help
I have a problem and i would be very happy if someone could resolve it.
This is my question to you: a would like to have one table in one sheet
that has, let's say 20 columns and 80 rows. And now somewhere on the
sheet there is something like a autofilter function in which I choose
which date i want. And now i choose one date and this table is blank
and i write things in the table,now i choose some other date and again
i write things in this table and so on. So I want to have like
20,30,40... tables at the same spot in one sheet and just to pick one
date and the table has values for t...excel 97 opening excel 2003
Is it possible to open with Excel 97 an Excel 2003 file which
include a choice list ?
It should be--but it kind of depends on what you mean by a "choice list."
If you mean Data|Validation or a dropdown from the Forms toolbar or a combobox
from the Control toolbox toolbar, then yes, it should work ok.
Gerard Marin wrote:
> Is it possible to open with Excel 97 an Excel 2003 file which
> include a choice list ?
> Great thanks
Thanks for your reply.
Into Excel 2003 :
It is simply "right clic" on...Does Excel 2003 have CDF feature in its histogram plotting function?
Does Excel 2003 have CDF feature in its histogram plotting function?
Here CDF means "Cumulative Probability Density Function",
We know that histogram is actually discretized version of PDF, which stands
for "Probability Density Function".
But where can I find the CDF plotting function in Excel?
Thanks a lot
I think you will have to write a function to integrate the pdf
Within a spreadsheet you can use the FREQUENCY() function on very
small partitions/bins to create the data via which you chart the pdf,
then doing a cumulative sum of the r...Excel: Reminder/Pop-up message
Hi Guru out there,
I would just like to ask for all of your help. I actually know basic from
Excel - I'm using version 2002.
I have an excel sheet, that has a column of " Termination Date " its date
format was 20081112(yyyy/mm/dd). Can you help me, on how to put a reminder
or pop-up message that I have termination date on or before 20081130 (Nov.30,
Also, if possible to turn to color RED - once it detected that its date are
for future dates? let say, I have termination date for Nov.30 and Dec. 10..
all future dates are automatically turn to color RED?
Hope tha...hiding columns, error message says cannot shift objects off sheet
Hiding columns on a spreadsheet ( which we do frequently). Error message
says: 'cannot shift objects off spreadsheet'.
WHat does this mean and how do I work around it?
excel thinks that there is data in column IV. excel by
default cannot shift data off the sheet ie beyound column
IV or below row 65536.
solution. highlight all the column to the right of your
data and hit the delete key. that should fix it.
>Hiding columns on a spreadsheet ( which we do
frequently). Error message
>says: 'cannot shift objects off spreadsheet&...Help website veering to the left what to do?
Is there a way to make it so the webpage always centers itself in the
middle of the browser, in stead of looking like it's being pulled to the left
if the browser window is opened up large?
Publisher left justifies the web pages by default, and if you are using 2003
or 2007, there is no way to center the web pages at this point. The best you
can do is simulate centering. Reference: Understanding background padding in
a Publisher web (aka white space) :
If you are using Pub 2000 or 2002 there is a way to cent...Charts in Excel
Is there a way to customize a grid line on one of the
axes? I am using excel 2000.
All of the regular gridlines in a set must be formatted the same. But
if you want to add a different one, or put them at irregular locations,
try the technique on this page:
Jon Peltier, Microsoft Excel MVP
> Is there a way to customize a grid line on one of the
> axes? I am using excel 2000.
Right click on the axis and the select &...Database records from excel templates
How do i get data entered into a template form such as invoice to update a
database. This used to work in previous versions of excel and is mentioned in
help but no where does it tell you how to set the form to do this.
There's information on the Microsoft site for the template wizard for
> How do i get data entered into a template form such as invoice to update a
> database. This used to work in previous versions of excel and is mentione...Excel #10
How to paste formated sheets to new file sheet? Formated sheet has artwork
(logo) and formulas that should carry as values only
Right-click the sheet tab and choose "Move or Copy." Choose "new book", and
check "Create a copy," then click OK. You will be in the new book. Click the
rectangle at the intersection of row and column headers, to select all, then
Edit> copy followed by Edit> Paste Special> Values. Save the new file.
"Mister B" wrote:
> How to paste formated sheets to new file sheet? Formated sheet has artwork
> (logo) an...Help 05-09-10
I have a toshiba satellite a100. When I turn it on it goes to a blue
screen that say "a problem has been detected and windows has been shut
down to prevent damage to your computer.
If this is the first time you've seen this stop error screen, restart
your computer. If this screen appears again, follow these steps:
disable or uninstall any anti-virus, disk fragmentation or backup
utilities. Check your hard drive configuration, and check for any
updated drivers. Run chkdsk /f to check for hard drive corruption, and
then restart you computer.
***stop: 0...Excel Queries with subqueries and parameters
I'm a developer newly aquainted to the beauty of excel reports via
pivot tables. So here's my delimma, I have a sheet in which I execute a
query. This query uses three parameters such as start month, end month,
and year to retrieve data from the database. This works great. As soon
as I add a subquery to the SQL statement that excel is editing, it
tells me that the query is not valid and that all of the excel
parameters contained within the query are bad. If I take those
parameters out, (for a test to determine if it thinks the sql syntax is
bad), and replace them with real...