Share Workbook command grayed out on menu/unavailable, Why?
I want to share the workbook I created but the command is grayed out on the
menu. Why would this be grayed out, is there a step I need to do before I
can share the workbook? Tag: please, please help Tag: 783555
Excel set up is right to left rather than left to right
Office 2003 was installed in Hebrew. Excel reads from rt to left than left
to right. i.e. columns originate in the rt and the rows are indentified by
number on the rt rather than the left.
How do I switch the format to English?? Tag: please, please help Tag: 783551
Limitations for Calculated Field formulas in Pivot Tables
Is there a list or even a guideline on what excel formulas are allowed when
creating a Calculated Field in Pivot Tables?
For example, I want to use the TODAY() function in the pivot table, but I
keep receiving errors. Is there a way to use a function that operates like
the TODAY or NOW functions within the Calculated Fields?
Thanks,
Brandon Tag: please, please help Tag: 783550
ABC Report
Hi,
I have a spreadsheet with the total sales for one month on items that were
sold and have been asked to do an ABC report based on this info. We want to
see how many items make up 80%, 15% and 5% of the total sales for the month.
Then categorize those items as A, B, and C items. Is there a formula that
can designate each item as an A, B, or C item?
Thanks, Tag: please, please help Tag: 783547
Excel 2003 colum
does anyone know if it is possible to increase the number of colums in a
single worksheet from 256 to 400 for excel 2003 ? Tag: please, please help Tag: 783533
Greater Than and less than HELP PLEASE
Tried for hours to get this to work and ready to throw laptop out of window.
What I'm trying to do :
enter mileage into A1
For first 200 miles charge £0.40 per mile for miles above 200 Charge £0.25
per mile and enter combinded charge into A2.
and if mileage is less than 200 in A1 carry balance (200-A1) over to B1 to
increase B1 £0.40 rate i.e 200 plus balance from A1
Hope that makes sense . Many Thanks for any help. Tag: please, please help Tag: 783532
Display #'s incorrectly (format)
=IF(AND(H3-O$1<0,M3-O$1<0,H3<>M3),"Past due
"&-MAX(H3-O$1,M3-O$1),MAX(H3-O$1,M3-O$1,0))
Formula above works great (Thanks to those that helped), but the problem I'm
now having is when account is not past due the other #'s return with serveral
0's. Example:00000 or 00221
I would like 221 to appear verses 00221 or 0 versas 0000
--
Elena Tag: please, please help Tag: 783527
0 bytes
I saved an excel 07 file that contained 300 kb of data yet, when tried to
re-open get a message saying the file is corrupt or I have the wrong file
extension.
When I look at the files properties it now says 0 bytes!?
Any ideas!?
Andy Tag: please, please help Tag: 783523
linking info from word and excel
I have a tool in excel spreadsheet that calculates scores and percentages.
After the calculations are complete, I have to transfer(retype) the results
and some of the info from that worksheet to a letter template in Word. In the
end I have to send out both the worsheet and the letter together. Is there a
way that I can combine both documents AND/OR have some of the info from the
excel worksheet to link and automatically update to the Word letter template
so that I don't have to send two separate documents and have manually type
the info from excel to word? Any suggestion is appreciated. Tag: please, please help Tag: 783516
Convert Date Format to Minutes
I have a spreadsheet from an outside source and the Minutes are formatted as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM but
in the actual cell, it looks like this: 94:00:00. How can I get the cell to
read just 94? Thanks!! Tag: please, please help Tag: 783511
Showing when a file was updated
I am trying to figure out how to have a cell display when a file was last
updated. Is there a way to make it show the most current date that any cell
has been updated. I have tried using =TODAY() but that doesn't change with
the most recent change. Tag: please, please help Tag: 783508
workday formula question
I am trying to create a schedule for a machine. I know how much of a day
each job will take. When I use a formula to just add column b to c, the
result actually includes the hour of the day, but I need to exclude the
weekend. When I use workday function then the fraction of the day seems to
not be included in the calculation. Is there a way to combine these
functions to add a portion of a day only using the work week?
B C b+c workday function=WORKDAY(C3,B3)
3.25 5/1/08 12:00 AM 5/4/08 6:00 AM 5/6/08 12:00 AM Tag: please, please help Tag: 783505
Printing pages from Pivot Tables automatically
I have created a Pivot table tracking expenses and quanities of items that
each dept in our company has purchased for a given month. I want a new sheet
to print for each dept. I know how to filter by dragging the dept number
into the page area of the Pivot Table but I have to select each dept
individually and print. Isnt there a way I can have excel automatically
choose each individual dept and print their expenses on separate sheets?
Thanks! Tag: please, please help Tag: 783503
Excel slow to save to network drive
I am trying to troubleshoot a machine that is running XP Pro and Office
2003. It is extremely slow to save files to a network drive with Excel.
Word is somewhat slow, but Excel is really bad. For example, it takes
almost 60 seconds to save a 175K Excel file. The server is in the same
building. I took a laptop down and plugged into the same ethernet hub
and opened and saved the same file. It took only 3-4 seconds. The
network in that office is somewhat slow, but still, there must be a
problem with the machine taking 60 seconds to save. The problem doesn't
seem to occur with local files.
What could be causing this?
Thanks,
Chris Tag: please, please help Tag: 783498
Adding Shapes to Spreadsheets
I want to add an autoshape to a spreadsheet, but when I go to Autoshapes ,
the selection choices are not highlighted. As a result , I am unable to
select them. How do I get the choices to be highlighted / available for
selection? Tag: please, please help Tag: 783479
Macro help
I'm new to macros, could some explain how I can use this macro to allow spell
check when a sheet is protected?
Using a macro is the only work around that I know of.
Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub
Unprotects the sheet, does the spellcheck then reprotects the sheet.
"justme" can be changed to your password.
Gord Dibben MS Excel MVP
On Sun, 10 Feb 2008 14:32:00 -0800, Brian <Brian@discussions.microsoft.com>
wrote:
>I made a spread sheet for work the has some cells protected then a password.
>But once I enable the password, the spell check cannot be used.
>
>Any help would be appreciated Tag: please, please help Tag: 783477
Hide a column "if"?
Hello,
I have a workbook with 250 sheets. I need to be able to hide column F unless
cell E2 has the value "Level 1". If there is another value in E2 or it is
blank, I need column F to be hidden. I need this on all 250 sheets. Is this
possible?
Thanks in advance, you are all always to helpful!
tgcali Tag: please, please help Tag: 783458
Saving an Excel Workbook
Dear all,
Is it possible to alter a workbook so that when a user opens it he/she is
automatically prompted to save it?
Also I have a cost model in Excel that has a cover worksheet in the
workbook. The cover sheet has a macro button that simply selects the next
worksheet. Is it possible to create prompt window to remind the user to save?
Thanks in advance,
Neil Tag: please, please help Tag: 783452
Do you know how to send a single worksheet in Vista Excel?
I want to send just one worksheet from an Excel workbook in the Vista
version. I want to send it not as an attachment but as the body of the
email. Any ideas?
Thank you, Tag: please, please help Tag: 783448
Difference between two dates with if statements
I'm a beginner...Please help
Dates are inputted in column M or H; but sometime dates are not required in
M and H which would leave it blank (if date is in column M there will not be
a date in column H and vice versa);
Cell B1 should always prompt today's date (=today())
I need column N to calculate days between them
example: B1=05/08/08 M=05/21/08 N should = 13
But if there's nothing in M and H it returns -39576
In that case I need "0" to be inputted verses -39576
and when B1 is greater then M/H column
I need the return to be "Past due "number of days between the dates"
Hope this makes sense.
Please help
Elena Tag: please, please help Tag: 783443
Alternative for Vlookup output of #N/A if data not found?
Hello,
Is there an alternative for the Vlookup function output of #N/A when data is
not found? The reason I ask is because I need to use an If function based on
the Vlookup output if the data is not found such as =IF(K2="#N/A","SPARE",)
but the function does not recognize #N/A.
Thanks!
Jaret Tag: please, please help Tag: 783442
Revealing the related pivot data
The situation is this...
Some of the people viewing my reports can click on the individual cells/data
value and it opens a new sheet revealing the related pivot data (or it
directs them to my pivot table). That said, others who do the same only get
the underlying formula displayed. It's almost like there is a feature that
needs to be turned on or maybe a patch that needs to be installed.
Can anyone tell me why some people can click to display the data and others
can't?
Appreciate the help.
Ken Tag: please, please help Tag: 783438
formulas do not work
I have added a column in my excel spreadsheet and copied the formulas from
the column next to it. The correct formulas are in the cells, but they aren't
working. I have to go into each individual cell and press F2 and enter for
them to update. How do I get the cells to automatically update? I have used
excel for years and have never had this problem. Tag: please, please help Tag: 783426
Default In-Cell Dropdown to a specific Index Value?
I have a scenario where I use a common list in a parent category (e.g. Work
Unit and a child category (e.g. Line Item) . I would like to default the
Line Item list value to the same list value as the parent Work Unit,
maintaining the in-cell dropdown structure in both cells. Tag: please, please help Tag: 783423
Merging Workbooks
Is there a way to merge or combine multiple workbooks into one workbook on
one worksheet without copying and pasting? Tag: please, please help Tag: 783421
Multiple Lookup Possibilities
I have a list which has an employer id and then employee id's. I need to
list all the employee ID's associated with one empoyer id.
I have a data entry sheet whereby the employer ID is entered; the next entry
is that of the employee ID. What I would like to create a drop down list for
employee ID's that would list all the possible employee Id's for a given
employer ID.
I would like to create a table that would be my list for the drop down box.
If I use a function like Vlookup it only finds the 1st Employee ID associated
with an Employer ID and thus my problem.
How can I create a macro to scroll down the Employer ID and Employee ID list
and populate a table of all the Employee ID's associated with a particular
Employer ID?
Note that I want to avoid cutting and pasting as I know this could be
accomplished via Data sort, etc. I would like some way to automate it. Tag: please, please help Tag: 783418
Excel formula
why does my formula change when I add data example
FORMULA BEFORE ADDING DATA =COUNTIF(D9:D6369,33)
FORMULA AFTER DATA IS ADDED TO THE WORKSHEET =COUNTIF(D242:D6369,33)
This is the data that is entered in worksheet
10 080501 S-BU-99-M 46 0277 DOLLEW 5/7/2008 9:23
10 080501 S-BU-99-M 46 0278 ALBGRA 5/6/2008 14:21 Tag: please, please help Tag: 783416
Excel Tabs
I have a worksheet with several tabs. Each tab is a different persons name.
Is there a way to have the name on the tab automatically show up in a
specific cell on the worksheet. Thank you! Tag: please, please help Tag: 783415
Excel & Keyboard
I am looking for a keyboard shortcut (or key combination or hot key) that
lets you switch from the "Find Box" back to the worksheet and then back to
the "Find Box". Does anyone know if this is possible? Thanks! Tag: please, please help Tag: 783406
Adding Times
How do I add times (in minutes and hours) but show the total in days, hours
and minutes? This for a working day so a total of 9h15mins should display as
1d1h15mins. Tag: please, please help Tag: 783399
show fractions rounded up to nearest 1/16th inch
I have cells formatted as fraction, up two digits. We are a mfg. company
cutting metal and if it is not on a tape measure, we don't use it. If we
input in an odd decimal value, we can get stuff like 17/20 or other wierd
unusable fractions. Is there a way to have the same cell of input to show a
result rounded up to the absolute nearest 1/16th of an inch? Tag: please, please help Tag: 783392
Save Current Sheet Only
I have a file that I use a pivot ( show pages) that creates 200 sheets
(customers). I then want to send each sheet out individually to each
customer. What is the easiest way to break up the file by each sheet
and save each sheet as an individual file?
Thanks Tag: please, please help Tag: 783389
Repeat Values in Column A, Break and Sum
I have data in Column A that repeats in groups; AAA, BBB, CCC, etc. Each of
these column A values is associated with a varible in column B. I want to
break at the end of a group and sum the column B.
Here's what I have and what I need.
What I have:
AAA 111
AAA 222
AAA 111
BBB 444
BBB 222
BBB 111
BBB 111
CCC 444
DDD 222
DDD 666
Here's what I want -- the break and the summation of Column B
AAA 111
AAA 222
AAA 111
444 (Sum of AAA)
BBB 444
BBB 222
BBB 111
BBB 111
888 (Sum of BBB)
CCC 444
444 (Sum of CCC)
DDD 222
DDD 666
888 (Sum of DDD)
I appreciate anything you can do to help. Tag: please, please help Tag: 783388
Validate Text for Pivot Table Filter
Hello,
I have source data for a pivot table that can contain one or more values
"alpha", "beta", "gamma", "delta" (ex: cell can contain "alpha", "alpha"
"beta", "delta" "gamma", and so on).
I tried a formula to display "yes" if the source cell contained "alpha" and
"no" otherwise as follows:
=if(isnumber(search("alpha",a1)),"yes","no")
Unfortunately, this returns "yes" in my destination cell whether the source
cell contains "alpha" or not.
I found this formula in another post on filtering pivot tables but can see
that I am doing something wrong. I just don't know what. I tried "istext"
in place of "isnumber" with the same result, a "yes" is returned regardless
of whether "alpha" is in the source cell.
Can someone tell me what I am doing wrong or whether there is a better way
to accomplish this?
Thank you,
Tom Tag: please, please help Tag: 783387
Conditional Formating (?) question
Dumb user here. I want to set a conditional formatting (?) rule so that a
row will highlight a certain color depending on if certain cells contain a
character (X). Example, if A1, B1, C1 and D1 each contain "X", the row will
highlight GREEN. If "X" is not contained within each of the cells, the row
will highlight RED. Tag: please, please help Tag: 783385
Printing excel 2003 spreadshets in Windows Vista
I am using Microsoft Office 2000 Pro - when I try to print received Office
2003 Excel files with my Windows Vista operating system, the spread sheet is
blank. When I try to copy the data from the 2003 Excel file to paste it into
the 2000 Excel, not all of the data is transferred. My only option is to save
the 2003 Excel file in text format in order to print the data. I do not have
any problems in opening the 2003 Excel file - the data is intact but I am not
able to print the data.
--
Jerry and Connie
CEB Tag: please, please help Tag: 783384
File opens, worksheet does not display
In Office 2007, I can open files (either .xls or .xlsx) but the
worksheets and data do not appear. If I maximize or restore the
screen, or if I hit the Office button, the data will show up. It
appears at first as if only the shell of the program is open until
changing the screen size or clicking the Office button, which reveals
the workbook.
If Excel is opened first, a blank workbook does appear normally. If
opening a file from within Excel, everything is fine. It is just when
double-clicking on a file from a saved location or opening directly
from an email message that this happens. This happens with all files,
even new ones after I create them and close Excel.
Any ideas...
P Tag: please, please help Tag: 783383
Scan group of cells and result based on condition
Hello,
I have group of cells in a coulmn, that have values of
N/A
N/A
N/A
N/A
B
The result cell should scan a group showing above and show result as B. It
means if any of the cell in the group shows B it should show B otherwise N/A.
If the group of cells would be
N/A
N/A
N/A
N/A
N/A
The result cell should show N/A. Any help please?
Thanks,
Manan Tag: please, please help Tag: 783381
Number Format Displays Differently Between Users
We have a spreadsheet with a column of numbers with General format (no actual
column format set) where the values appear like the following to most users:
100234.0002
992233.1203
232311.0003
But a new user who obtained this spreadsheet is seeing the values as
1.002.340.002
9.922.331.203
2.323.110.003
Spreadsheet created in Excel 2003, and new user supposedly has same version
(although I have them checking this). I don't have the user's actual Locale
info yet, but I know they work out of Belgium. We have other users worldwide
who see the data formatted as expected.
While I have the user tracking down their version, locale, and "options -
international - number handling" settings, anyone have an idea of what is
causing this, and the easiest way to resolve so they see the number diaplyed
as everyone else does? And what settings in particular would be causing this?
As always, thanks for all your help! Tag: please, please help Tag: 783380
Counting highlighted cells
If I want to count how many highlighted cells there are in a row or column is
there a formula that will do that for me - there will be no numbers in these
cells just highlighted. I would want each highlighted cell to count as 1. Tag: please, please help Tag: 783371
enter refresh date in a table
I have a table connected to a SQL view. It is not a pivot table.
How do I enter the last refreshed date into a cell at the top of the page. Tag: please, please help Tag: 783370
Save current sheet to new file
Can you tell me if I can automatically save an open sheet to a new file?
I have a workbook that calculates a job cost from Quotation, Ongoing and
Invoice on differnet sheets but would like to save the invoice sheet as an
additional seperate file. Tag: please, please help Tag: 783364
How to do this formula?!
Hello,
would like to know if someone can help me.
My question is:
Which formula i have to use to have in one of the excel sheet thee last
value that appeared in another sheet?
Exp:
In the sheet 1 i have a set of values
day 1 = 20
day 2 = 30
day 3 = 40
Today = 60
In the other sheet i have to use a formula that calculates the result with
the today´s value.
Well, i think there is a way of doing that automatically without change
everyday the the cells in the formula.
If someone could help!!
Thanks Tag: please, please help Tag: 783360
Transition Link functionality from Excel 2003 to Excel 2007
I have a HUGE number of spreadsheets developed while using older Excel.
Default settings for all old spreadsheets were to:
1) Not automatically update links on open
2) Not automatically update links on calculation
3) Not automatically update links on save/close
Excel 2007 enables all those when I open the legacy spreadsheets, updating
the values and forcing me to change properties on every file I open (via the
Home button and the excel options). In the excel options button you can only
set this preference at the worksheet level.
Is there a way to make this a global option that Excel 2007 defualts to for
every file opened - allowing me total control from the initial opening to the
save. Tag: please, please help Tag: 783359
Date formatting in Excel
In Excel, how do I get my date to read like this: June 2008. I do not seem
to have this format available in the date formatting window for Excel. Can I
create a new date format? Tag: please, please help Tag: 783357
Pareto database
hello,
I have the following database:
item item spend responsible
1 200 peter
2 400 jack
3 50 peter
4 2000 julie
etc.
each person is responsible for a number of items and thus a total spend.
I would like to create (ideally) a pivot which shows a pareto on spend and
number of items (e.g. Peter's complete spend is 23500 on 42 items, 80% of his
spend is on 7 items, 80% of his items amount to a 40000 spend).
Can anyone please tell me how to do this?
Thank you very much in advance!
E. Tag: please, please help Tag: 783356
please, please help
how do i get sheets, duplicated from a master sheet, to automatically number
a field in each new opened sheet consequetive to the previous sheet.