|
Attendance database setup
I am creating an attendance database for my company.
There are 19 different departments in the company and each manager tallies
his/her own employee attendances.
I had a spreadsheet set up, but it wasn't on a rolling calendar basis. Then,
I was going to have the managers delete old months, but that would most
likely mess with the formulas.
So the new spreadsheet needs to be on ...
|
1 |
07.07.2006 15:28:02 |
|
|
How to copy print set up to other excel worksheets?
I want to copy the print set up including page breaks on to multiple
worksheets but when grouped this function is greyed out. Pasting just the
format does not copy the print set ups across to another work sheet. I do
not want this print set up on all my worksheets, just a few.
Anyone know how to copy print set ups to other sheets?...
|
2 |
06.07.2006 23:30:44 |
|
|
Excel Hang - kernell32.dll accountable
Some times, tracker ( a program that uses excel to build tables) users saw
office application (excel and/ PowerPoint) frozen (hung) when they are using
results from tracker to build presentations (introducing tables more often).
In the Event viewer, entries exist for event ID1003: “Hanging application
excel.exe, version 11.0.8012.0, stamp 43e2ab74, hanging module kernel32.dll,
version...
|
1 |
06.07.2006 16:42:01 |
|
|
excel viewer
my computer fails to reconize that it has excel viewer, when I try to install
it into my PC it asks for the 25 case numbers. I lost the case numbers is
there any way I can get the case numbers from a web site??????? Thank You...
|
7 |
06.07.2006 15:10:11 |
|
|
Resizing a field in "forms"
I'm using XL as a database and find that adding or viewing information is
very helpful. The only draw back is that I have a field named "comments" that
I would
like to resize so that I can see all of the information in it. Is there a
way to expand this field?
Any input would be very helpful.
Thanks
--
GlennO...
|
1 |
06.07.2006 14:40:03 |
|
|
Excel OLE error
Hi everyone,
we are running all apps on Windows Server 2003 Terminal Server. All users
access Microsoft Office products while being connected to Terminal Server.
Quite often users reports that when they try to open excel spreadsheet the
get such error: "Microsoft Office Excel is waiting for another application to
complete an OLE action". Visually Excel is closed, but excel.exe is running ...
|
3 |
06.07.2006 12:16:02 |
|
|
Column Labels Automatically at the top of each page?
I would like to have the column labels appear at the top of each page
automatically. I am working with a spreadsheet in which I am either adding
rows, or wrapping text in a cell so that particular row gets wider, which
changes where the page breaks are. As a result, every time I work with the
spreadsheet, I have to manually move the column labels from their current
rows to the row at ...
|
4 |
05.07.2006 19:38:00 |
|
|
How do I set up tracking chart
I am trying to set up chart to record author, book name, date, CD/read, and
brief comments. I would like to be able to quickly determine if I have
already read a book in question and/or review comments of previously read
books. Is there a way I could do this using Word? Thanks for any info.
--
Louisa...
|
2 |
05.07.2006 12:59:29 |
|
|
lose selected range when I right click
I have somehow lost the ability to use the right click shortcut menu on a
range of cells. Anytime I right click the selected range reverts to the one
cell I am on. I have tried downloading updates and detect and repair with no
success....
|
2 |
05.07.2006 07:48:02 |
|
|
Unable to follow Hyperlink via keyboard Enter button
I used to be able to follow the hyperlinks by a mouse-clicking the cell and
also by using keyboard Enter button after to have selected the cell
containing the link. But after upgrading from Excel 2000 to Excel 2003, I can
only follow the link by mouse-click. (When keyboard “Enter†button is
pressed, it only takes me to the next cell at the bottom of active cell
instead of following t...
|
2 |
04.07.2006 11:27:18 |
|
|
Excel 2002 SP3 - Exit button is not available - grayed out.
We have uninstalled and reinstalled MS Office Suite. We have run Detect and
Repair. When you first open Excel the X button is visible, but is not
enabled. After working in Excel for a few minutes, the X button will gray
out. You have to select File and Exit to close the application....
|
3 |
03.07.2006 12:31:18 |
|
|
How do I put the clipboard on top as in Office2000?
I just "upgraded" to office 2003 and the clipboard takes up way too much
space. Is there a way to make it small and on top of the
spreadsheet/document the way it was in office 2000?...
|
1 |
03.07.2006 11:10:02 |
|
|
data from Paradox to Excel
Can Excel (Office 2003) load Paradox 4x data in an XPpro environment? Data
queries set up using Excel (Office 97) in Win98 and Win95 have always worked
fine but those same queries don't run on an XPpro machine. Nor can queries
be created using the same settings even though Excel 2003 provides Paradox 4X
ODBC drivers.
Does this mean that XPpro cannot handle DOS based Paradox data? Any he...
|
3 |
03.07.2006 02:29:01 |
|
|
AutoSave.xla Add-in
I have a excel version 2000 SP running in Citrix Server and I would like to
install the Autosave.xla.
I click in Tools > Add-ins but don't show me the option of this componente.
Someone know how can I install?
Thank you.
...
|
4 |
30.06.2006 23:50:20 |
|
|
How do I remove the header from only one page?
I need the header on all pages except the last one. How do I remove it from
the last page?...
|
2 |
30.06.2006 16:54:26 |
|
|
Retrieving SQL data into Excel - Part II
Hi,
I have rather complex SQL Server query using CASE function, table joins,
etc. that I was able to execute in MS Query (MSQRY32.exe). However, when I
try to export or open the saved query file (.dqy) into MS Excel, it reports
an error (Microsoft Excel could not open or read this query file. Either the
file has been damaged or the file format is not valid).
Has anyone seen this befo...
|
1 |
29.06.2006 21:47:02 |
|
|
Print multiple excel sheets in color
Hi, I've got a problem.
In Excel I have 3 sheets. On all these sheets I have some colored cells and
text.
Now I want to print these sheets. On my printer preferences I select "Print
in color"
When printing is done only the first sheet is in color. The other 2 sheets
are in black and white. The printer I selected for printing is a Xerox
WorkCentre Pro 40C. For these printer are the...
|
2 |
29.06.2006 11:10:37 |
|
|
d_to_change_$_to_£
Based in UK
Using excel invoice template, when I add my figures and tab across a $ sign
comes up. I need to change this to a £ sign, but how.
Any help welcome.
Thanks Jason...
|
2 |
28.06.2006 21:03:31 |
|
|
Can't load Excel Executable
Hi People,
Hope you are well?
I have a question, hopefully you may know the answer to:
Scenario:
1.)Office 2003 loaded on XP machines.
2.)We took away the User's rights (As they messed around on the system
too much,The user can't see "C:\" when opening My Computer)
But does have Excel in the Start -> My Programs Menu.
3.)We have a third party application running (basically all it ...
|
1 |
28.06.2006 10:50:09 |
|
|
Excel should high-light Rows & Columns when cell selected.
Excel should have a feature to high-light the row and column when a cell is
selected for data entry users and when manually searching spreadsheet.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
l...
|
2 |
28.06.2006 10:26:13 |
|
|
How do I restore the default settings in Excel 2003?
I have used VBA to alter the user interface in Excel 2003. In the process
Excel crashed and has left remnants of the VBA generated interface. I wish
to get back to Excel default settings without having to reinstall Excel. I
have tried all the normal methods outlined in Excel 2003 help to no avail.
Thanks....
|
3 |
28.06.2006 05:57:01 |
|
|
suggestions on creating a text value based on a date range
I have a situation where I need to compare week1 from one year to week1 from
another year. The problem is that I have the dates, amounts, and categories
in a raw dump from an external application in a text file and am able to
import it into Excel. The issue that I need to do is to be able to create
another column that will contain the week identifier based on the date
column.
exampl...
|
1 |
28.06.2006 01:44:02 |
|
|
Retrieving SQL data into Excel
Hi,
While I can retrieve data from a SQL Server into Excel successfully, I'd
like to filter the data by specifying a criteria where the date column from
the SQL Server database is greater than or equal to the current date.
I have tried using the TODAY() Excel function but to no avail. Has anyone
else tried this? Your comments, help, and suggestions are highly appreciated.
TIA.
Reg...
|
2 |
27.06.2006 22:18:06 |
|
|
multiple spreadsheets
Hello,
What must be done to open several spreadsheets side by side?
Is that possible?
I am using Excel 2002 SP-2 and I can only toggle between several
spreadsheets. Is it possible to see them all at once?
Jack
...
|
4 |
27.06.2006 19:10:25 |
|
|
How can I import my special WORD toolbar into EXCEL
I have EXCEL 2002 sp3 on WinXP Pro. In Word I have a customised toolbar with
different print options (ie print simplex, print duplex, print on a second
printer). How can I import or copy this special print toolbar into EXCEL ?
thanks ... Roger
...
|
1 |
27.06.2006 17:21:31 |