Excel and MRP. Scheduling...
Does anyone here uses Excel sheets to calculate MRP, Scheduling, and s
on? Need to exchange some ideas...
Message posted from http://www.ExcelForum.com
Message posted from http://www.ExcelForum.com
...Copying Border Formatting
I have a large spreadsheet which is essentially a diary.
I want to format the days and weeks, with thin and thick borders to
distinguish between them. The spreadsheet already has lots of varied fill
formatting for meetings that are held.
I can't see a way of either format painting, or paste special-ing, just
Is it possible?
Stanley: It's not gonna end like this.
Gabriel: Oh, come on, Stan. Not everything ends the way you think it should.
Besides, audiences love happy endings.
True enough that...Cell formating in Excel?
Is there a way to have a scroll bar in a single cell?
"pmarina" <email@example.com> wrote in message
> Is there a way to have a scroll bar in a single cell?
...Inserting Columns in Excel
Operating System: Mac OS X 10.5 (Leopard)
When I select a column or columns to enabalize inserting additional columns, nothing happens. I can't get columns to insert in either the page layout view or the normal view. Why is something so simple not working? All I get is a little paintbrush icon that wants me to decide if I want the formatting of the adjacent column or not. Please help, it can't be that hard!
No offense, but my guess is that you're misinterpreting the feature &
perhaps using it on a blank sheet. The command does not increase...Naming columns in Excel
I am trying to set up a database in Excel. I need to change the columns (A,
B, C,...etc) to name, date, ssn, etc. I am having trouble and dont know how
to do it. PLEASE HELP!
I want to be able to have each column name to reflect the information that
will be put in that respective column.
Thank you for your help
you can't change the column headers. The best you could do is use the first
row as heading row
> I am trying to set up a database in Excel. I need to change the columns (A,
> B, C,...etc) to name, date, ssn, etc. I am having troubl...Excel function names in different languages
One of the most annoying "features" in excel has been that excel only
recognizes the function names in the language the excel is for. I
myself have Finnish (language from Finland) excel at home and English
excel at work.
Now you can believe the mess I'm in when I have used excel at work
whole day using english functions and start to use excel at home.
That's just not very convinient. Is there any way to enable i.e.
Finnish excel to understand standard english functions?
Is there even a reference list out there where I could check what any
given english function nam...Excel 2007 Crashing Problem #3
My company has been riddled with Excel 2007 crashing since we started
migrating to the 07 suite. Two users who prominently use Excel for their job
tasks have seen many issues mainly when converting .xls documents to .xlsx.
The common theme i have seen here has been file size and weather or not the
file contains links. Both users also work heavily with graphs.
My question is, has there been reported problems with converting large excel
files to the new format? Or has there been a graphing problem?
When I double click an Excel file in Outlook, I get the
message "The system cannot find the file specified".
However, for Work, PDF or other files, they work just
Can anyone tell me what the problem is?
have you got Excel installed?
"joey williams" <firstname.lastname@example.org> wrote in message
> When I double click an Excel file in Outlook, I get the
> message "The system cannot find the file specified".
> However, for Work, PDF or other files, they work just
> ...Formula Excel
Wondering if someone would be able to help me with this:
A B C
Year Year Service
01-Sep-89 30-Jun-10 = 21 Years
From September 1, 1989 to June 30, 1990 = 1 Year of Service.
I know it only 10 months, but that is their year.
Is there a formula that could caculate the number of years
from September 1, 1989 to June 30, 2010.
The general formula for years between dates is
=Year(latest date) - Year(earlier date)
and 2010-1989 = 21 years. So that might work for most cases? A
complication arises if they begin, but do...How do I doanload Excel 97?
I'm taking a accounting class on line and our teacher say we can download
free templates. I can download the templates but I can't edit or do the work
to email to my teacher. Every time I go to open and edit it tells me that
microsoft excel is not downloaded correctly. Help me please because I have
to turn my work in.
you need to actually purchase excel 97 - templates are just predesigned
However, having said that, the latest version of Excel is 2003 (so there's
excel 2000 & 2002 between 97 & 2003). The latest version can be purchased
from just a...making the header larger in Outlook 2007
I am a new Outlook 07 user. Is there a way to increase the size of the To;
From: Subject line when composing or reading an email?
> I am a new Outlook 07 user. Is there a way to increase the size of the To;
> From: Subject line when composing or reading an email?
They get as wide as you make the window.
To increase the font size? No.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:email@example.com...Excel 2003 to Excel 2007 graphs
I have a bunch of Excel 2003 graphs that are now being updated with
new data. In the course of this, we are also saving as Excel 2007
macro-enabled files (.xlsm). Any time the file is saved it has a
message re: invalid name or range and says it will change the name to
"_CHARTA_xxyy" for example. You are prompted to say "okay" or "okay
to all". If I follow it through, there are about 82 instances of
this, so I figure it has to do with components of the graphs on the 2
worksheets. There are a total of 4 graphs. Any quick solutions to
this compatibility ...format text in excel
How do i format a text cell in Excel, for example: 1122AA to 11-22-AA
Assuming that the text 1122AA is in cell A1 -
"JFlorindo" <JFlorindo@discussions.microsoft.com> wrote in message
> How do i format a text cell in Excel, for example: 1122AA to 11-22-AA
if the length is fixed, and your text is in cell A1, then use:
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGH...Excel XP Bottom Double Border Problem
I had previously corresponded with Debra on this subject, and have
followed the suggestions on creating a macro for the button. It works
while excel is open; but when I close and re-open excel it does not
work. I have to re-assign the macro to the button. What have I done
wrong? Is there a solution to this?
A couple of observations:
1) A few of the steps described in Dave Peterson's suggestion can be
skipped: select tools > customize; right click on Bottom Double Border
button (if it is already on toolbar - if not then go to format & drag
the button to the toolbar); then assign mac...Select Inner.* from nested(outer)-nested(inner) query
Is it possible to "SELECT *" just the fields of a sub-nested query
(i.e., I don't want * of a nested query, but of a nested-nested
For example (SELECT Inner.*):
, ROW_NUMBER() OVER ( ORDER BY x ) AS ROW
) AS Inner
ROW BETWEEN @Start AND @End
) AS Outer
So I want the result to be everything from the sub-nested query (and
not the extra fields added in the nes...Formatting Excel
I have a table in excel, all of the information in this
table is linked to AutoCAD. I have added an example below:
NO. NAME BOTTOM BOTTOM TOP TOP
MAT FIN MAT FIN
101 CORRIDOR PLASTIC SMOOTH RUBBER SMOOTH
102 CORRIDOR PLASTIC SMOOTH RUBBER SMOOTH
I am trying to get Example 1 to look like Example 2
without having to re-enter everything. It is the same
info. but a different layout. I tried a Pivot Table but
was not successful. Does anyone have any ideas?
NO. NAME BOTTOM TOP
10...Error opening Excel File
I'm currently having these days an error while opening an
excel sheet. The sheet is shared among five users. When
one tries to open it, a message indicates that the file
is locked for editing by another user and after checking
with the user, I understand that he has already closed
the file but the latter remains locked. Can someone help?
...Excel Save button
Version: Excel 2002 (10.4524.4219) SP-2.
We recently moved and updated links from about 14,000
excel files from a Novell Netware environment to a
Microsoft Networking environment on a Win2k server. We
had to do some "linking" issues on several thousands and
the files seem to be working fine. The issue that we are
experiencing are files on the network that you open up on
the client machine, make even a few characters on a cell,
and try to SAVE it, when a SAVE window dialog box comes
up and asks if you want to save it as, "SAVE AS"
or "Overwrite." It give...show month number as month name in Excel?
I'm trying to format a field in an Excel Spreadsheet in such a way that it
displays a month name rather than a month number.
For Example, if a cell contains 8, I want the cell to show as August.
Conditional formatting only allows me 3 levels of condtions and isn't
I don't think you're gonna be able to use formatting for this.
But you could use a helper cell:
if A1 contained the month number.
Format this cell as MMMM
and you can keep the value as a real date.
If you want the text string fo...signing VBA Macros for Excel
Below is a question from one of my friend. would be great if someone can
"We have a requirement to sign VBA macros in Excel sheet, will only
self-signed certificates work or any certificate installed in root
certificates folder can be used, if yes how to install the server
certificate to use in Excel VBA"
"C.Prashanth [MSFT]" <firstname.lastname@example.org> wrote in me...policy border
What is a policy border? I am using a long document that was created by
another user, and am adding text. I noted under the formating that policy
border is selected but I cannot tell what that is.
Probably a Style created by the other user/creator of the template upon
which the document is based.
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"CIW" <CIW@discussions.microsoft.com> wrote in message
news:5F2403E1-4189-4C2D-8DEB-68589AF...When I add a row to excel how can I stop formulae changing
I've done this before, but can't remember how.
I want to add a row at the top of a sheet, but without formulae with a range
eg =sum(a1:a5) changing to =sum(a2:a6).
$ isn't the answer
> Kostis Vezerides
Thanks for that.
How about if I after inserting a row A1:A5 changes to A1:A6
...If statement in excel
I need your help in preparing an evaluation sheet...
1 Total 75
2 Completed task A Yes
3 Completed task B Yes
4 Completed task C Yes
5 Total score based on task X
Given above is an example of how the sheet looks consider A as the row
and the numbers in the side as coloumn.
B1 has the value of the total score by measuring some other tasks. But
B5 will contain the actual score of an individual after measuring the
3 main task mentioned...Marquee in excel?
Has anyone ever heard of a marquee in an excel work sheet?
I'm wanting to put one in but cant seem to be able to.
I've been using Office 2003 in the past and just upgraded to 2007 but cant
seem to find any way of doing it.
The following link would be relevant
"Stewart2003" <Stewart2003@discussions.microsoft.com> wrote in message
> Has anyone ever heard of a marquee in an excel work sheet?
> I'm wanting to put one in bu...Excel Changing hyperlink
where is puts the ../../../../ instead of the network location.
I searched and found some good information, just wondering if there is a way
to get the ones that have already been changed by excel, to be changed back
to there original location, without having to do everything manually.