I wondered if anyone can offer advice/help regarding my dissertation
project.  Basically we are currently using an excel workbook which contains
worksheet for each use to record working time.  I have to provide an
solution that allows concurrent user access where the data entered is ...

I have recently noticed that all my excel documents now open with filename
[SHARED] displayed in the title bar. I can now no longer edit graphs :-(
The problem persists if I copy the workbook to another machine.
Can anyone tell what my problem is and how to solve it

I have a spreadsheet where I import daily data into
worksheet A.  Sometimes there will be 5 rows of data and
sometimes 1000+.  Then inside the spreadsheet I have
Worksheet B that runs some formulas based on Worksheet A.

How i can fix my excel problem.?
When ever i run excel.exe i got book2,where it suppose to be book1

Hello, all!  I'm new to this group and trying to figure out a way to query
data from SQL Server 2000 into Excel to graph.
Basically, I have one row of data that is collected on a weekly basis that
reports the size of a various file that we send to customers.  I would like

I got exercise asking to enter formula to compute "the years of service"
using "=(Today()-E2)/365" formula in cell "D2" in table where :
cell E2 is Hire Date 11/24/93 and cell D2 is empty.
Everytime i enter formula it keeps giving error result #VALUE.

How can I automatically remove duplicate rows in an Excel spreadsheet?

Is there a way to change the colour of one "Sheet Tab" , among 12 others?

My sheet is complete on one page and within the margins.  For some reason
when I print it prints a second page which is blank except for the header
which repeats.  There are some bordered cells past the page break on the
right.  I have tried to delete these, but the borders ...

I just created an excel catalog for my cd jukebox as I loaded the tray (300
discs).  Now I want to alphabetize column A (artist) and have column B
(album title) follow column A.  Is there a way to do this?  Thanks for all
help.

I just created an excel catalog for my cd jukebox as I loaded the tray (300
discs).  Now I want to alphabetize column A (artist) and have column B
(album title) follow column A.  Is there a way to do this?
Thanks for all help.

I am facing strange problem importing Excel file to SQL Server using DTS.
Certain cells which are having numeric values are not getting imported. I
mean they appear as "Null" values on importing to SQL Server.
If I add "'" in front of this numeric values it gets imported.

Can someone suggest appropriate software.  I currently
have a SQL db that holds most of our business data.  I
regularly create queries in an Access db that has linked
tables then import the queries into excel to use in pivot

Obviously the number of rows and columns provide a limit to one
extent.
But by adding pivot tables charts etc, one can generate quite a large
file.

Is there a function in VBA to detach a sub range of cells. Eg. Have range
A1:F10 and want to remove cells A6:F10.
Thanks for any help