Help with Excel
I have windows xp on my new computer and it don't support
excel, i have file on my old computer with excel how can
i get excel to work with my xp version
You will need to put Excel on your new machine - it is NOT part of Windows.
If you have the Excel or MS Office disk from the old machine you can use
that to install the applications on the new PC. Of course, once you have it
running you must uninstall the apps for the old PC. You can install Excel
97, Excel 2000, Excel 2002 or Excel 2003 on the new PC.
If you do not have the disks then you are in for a shopping spree.
Berna...If I want to buid a simple database for customer details, should I use Excel or Access?
I want to buid up a database for store detailed information of customers.
The key words would be contained Customer's name, contact, visited time,
email address links ( That can be easily used for sending emails).
I wonder which program is better, Excel or Access? I am thinking that Excel
is more common to use. And If I set up Excel, its data can be imported to
There are two clues here. The first is "database" - Access is the database
The second is that, in spite of that, you fancy Excel, probably because you
are more comfortable with Excel.
It is yo...Excel and Windows Live Mail
I update my Mail add-in and VBA code examples to avoid the error if you use Windows Live Mail as your default mail program.
More information in the blog post :
If you have problems let me know so I can update the code/add-in if needed
Regards Ron de Bruin
...ODBC server changed
I have some Excel 97 files that used to pull in data from a Unix box using
an ODBC driver (U/SQL from Transoft). We have upgraded to a new server
which has a different IP address and now the embedded queries have stopped
Is there any way to change the data source in the Excel 97 file? I noticed
by opening the file with a text editor that the old IP address is buried in
there but I can't change it as it corrupts the file.
The query was created with Data > Get External Data > Create New Query. It
has not been saved as a separate MS Query file. If I do manage to edi...Linking to Another Excel File (File Name Changes)
I have 2 separate Excel file worksheets. Basically, one file is
updated each month and will have a different name (example: File052007
for May, File062007 for June, File072007 for July, etc.). Currently,
I'm trying to link cells in my other file to the updated file, but I
don't know how to set the link so that it can change each month. I was
trying the concatenate or (A1&A2&A3) options to try to link cells
together, but haven't had much luck.
Here is what the formula should look like:
I made 2 cells in this worksheet ...Excel charts won't appear or preview. Help!
In Excell 2003 I cannot get my charts or graphs to appear or preview. I was
able too at first. But I accidentally hit right click and then clear several
times after having created template line chart for the first time. This
subsequently one at a time removed different aspects of my chart until my
chart was gone. And now i cannot get the charts to appear again. Not even a
preview. Thank you in advance foe your help and advice.
This problim has been solved. Thank you.
...Open A Network Folder From VBA
I'd like to be able to open a network folder when a user clicks a button on
a form. The shared folder has a static name, but the sub folder will change
with each record. For example....
Shared Folder \\server\share\folder
I'd like to have it set so that when a user is in ProjectNumber 123, they
click the button and the folder \\server\share\folder\ProjectNumber opens.
Any help would be much appreciated.
At my job all users have Windows 2000 or Windows XP, and I use
something similar to the follo...Adding and subtracting hours in Excel 2000 worksheet
I'm having some success with the addition part but not with the subtracting part!
I have an Excel spreadsheet that is used to keep track of time worked by staff on a weekly basis and I need to keep track of the overtime worked. For example, one staff member has worked 40 hours, 54 minutes and 25 seconds in a week (displayed in a cell as 40:54:25 with the cell formatted as Category: --> Time and Type:--> 37:30:55).
I then went to subtract 40 hours from the total hours worked to get the overtime displayed and thats where I'm having the problem. I tried the format of "=F9 -...macro needs info on currently highlighted message in search folder
I created a search folder, "Messages Sent Or Received Prior To 2008)
by using the Advanced Search and creating a query. The list of
messages is shown, including just the lowest level folder name.
I can navigate through the messages, and I'd like write a macro to
show the full folder path of the currently selected (not opened)
message, because I have many dozens of folders and they're not all
named uniquely at the lowest level.
Can this be done?
Show it where? Outlook version?
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Program...Microsoft Excel #2
Why can't I close my Excel application by clicking the x button in the
upper right hand corner of the application. This is Excel 2002.
Is there a way to do this?
Message posted from http://www.ExcelForum.com/
Is the "x" button grayed out and unavailable?
Are using using Groupwise?
If that's the problem. See this MSKB article
Article is specific for 2000 but I think it is valid for other versions.
It gives a workaround (use the file menu) and instructions as to how to remove
the Groupwise add-i...table of contents in excel
Does anybody know how to create a dynamic table of contents in Excel (similar
to Words TOC). Or alternatively how to insert the current page number into a
cell so that it can be cross-referenced.
See David McRitchies TOC page:
"nickH" <nickH@discussions.microsoft.com> wrote in message
> Does anybody know how to create a dynamic table of contents in Excel
> to Words TOC). Or alternatively ho...excell formula needed
In Excell, I'm trying to match a cell (eg H21,with a num value (eg
2530) to a column of figures (M34:M99) that has one match in it and
produce a grading A, B, C, D from a column (N34:N99). Anyone have any
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
"terrificRob" <terrificRob.email@example.com> wrote in message
> In Ex...opening excel document with shell as read only
I am presently using access to open an excel file by using the shell
command. Is it possible by some command e.g. \readonly to open the excel
file as read only?
If you're automating excel from another program, you may be able to just create
an instance of excel and open your workbook readonly:
This worked for me from MSWord:
Dim myXL As Object
On Error Resume Next
Set myXL = GetObject(, "Excel.Application")
If Err.Number = 429 Then
Set myXL = CreateObject("Excel.Application")
On Error GoTo 0
myXL.Visible =...Scroll Bars Do Not Appear in Excel XP
One of our Office XP for Small Business users (running Win XP Pro SP 2) is no
longer able to see the horizontal scroll bar in any of his Excel files --
files that used to display correctly a few days ago. He also can no longer
see the three colored buttons in the top right of the screen (for Minimize,
Zoom, Close). The scroll bars are set to display in the Prefs and we haven't
changed any settings on our monitor -- any idea what we should do?
Are the windows just not maximized? Try double clicking
on the title bar at the top of the file and see if it
snaps back into place.
&g...My IMAP Inbox is showing in calendars, not in the mail folder
Help. This is driving me mad. When I click on the IMAP master folder in the
mail view I don't see my inbox. It's in the calendar view and I want to move
it back. any help gratefully received. Adam
...Macro Not Loading XLSART excel
I have created a macro and placed into the xlstart folder
and the macro will load at first. At some point, the
macro stops loading, yet the macro is still in the
Macros don't load from the XLSTART folder.
Workbooks load from the XLSTART folder. The macro must be in workbook.
Is your macro stored in a file named Personal.xls or in another workbook?
Is the macro in a general module or Thisworkbook module or Worksheet module.
Show us your macro code.
More information please.
Gord Dibben Excel MVP
On Mon, 10 May 2004 15:05:49 -0700, "S Crowel...size of public folder
I would like to know where the public folder information is stored, ie the
path to public folder. I need to determine the size.
Can someone help me on this
Right click the public folder store in ESM, and choose properties.
The paths will be shown on the Database tab.
"Song Tan" <SongTan@discussions.microsoft.com> wrote in message
>I would like to know where the public folder information is stored, ie the
> path to public folder. I need to determine the size.
> Can someone help me on this
>...HELP!! Windows Explorer Hangs on Startup!
I've had this Presario 2195US laptop for 4-5 years; running XP from SP1 to
(now) SP3... no problems. 2-3 weeks ago, I tried to connect a 160gb
USB-encased hard drive with no luck... proceeding along I pretty much hosed
Anyway, I decided to reformat/install a copy of XP Pro w/SP3 (thought XP
Home didn't like 160gb) and, after a few MS updates, every time I boot the
system it shows the DESKTOP, the bottom left of the TaskBar and NOTHING on
bottom-right. Cursor moves, I can Ctrl-Alt-Delete and, when I move cursor
to TaskBar area... cursor turns in...Getting data from Access to Excel?
How would you go about pulling data from Access database into Excel? (Like
Data|Get External Data|New Database Query
Select MS Access Database
The Wizard should take you through the remaining steps of selecting the data
you want to import and the criteria (if any) that you wish to use.
"Troy" <firstname.lastname@example.org> wrote in message
> How would you go about pulling data from Access database into Excel? (Like
> weekly reports)
You can also push-it-out of Access to Excel by (While...still can't use Entourage, PowerPoint, Excel
I posted here several weeks ago and this problem couldn't be resolved
then -- not entirely, anyway. I'm trying again because I haven't been
able to find anything more anywhere else, and there WAS one thing I did
right that I would like to duplicate -- plus, I'm pretty sure I can
pinpoint when this problem started.
When it started, I'm fairly certain, was when I downloaded the last
Software Update of Office for Mac. This had to have been right around
April 18, because I remember having downloaded the update late at night
while I was working on something else, then rather th...replacement for favorites command in Excel 2007
In excel 2003 there was available web toolbar with favorites command. That
allowed quickly to find files. For some reason web toolbar is not available
in excel 2007. Is there any alternative for the favorites command or is this
possibility of saving files locations just disappeared?
> In excel 2003 there was available web toolbar with favorites command. That
> allowed quickly to find files. For some reason web toolbar is not available
> in excel 2007. Is there any alternative for the favorites command or is this
> possibility of saving files locations just d...Arabic/Farsi in Office 2004 (Word and Excel)
How do you setup Word 2004 and Excel 2004 to type right to left in
arabic or farsi. I have enabled Farsi and arabic in the international
pane of the System Preferences and I am able to type perfectly ok in
TextEdit. However when I type Arabic or Farsi in Word 2004 the
characters appear but they do not connect to one another as they do in
Any ideas on how to fix this??
You can not type right to left in Office:Mac yet. This is certainly
something to expect from the next version of Office:Mac...
With Office:2004 dating from mid 2004, I can expect that the next Office
might come out ...How to open Excel docs default with Excel 2007?
I had Office 2003 installed, then installed Office 2007 as well. The
system was automatically configured then to open all Excel files (2003
or 2007) in Excel 2007.
However, here at work they just did some Office 2003 update, and now
XLS files are opening with Office 2003. If I go into Windows explorer
and to file types and find XLS, when I browse to the office 12
directory and select EXCEL.EXE as the file used to open, it simply
selects the "Microsoft Excel" that's already in the "Recommended
Programs" section (at the top) of the "Which program to open the file
wi...Adding a Folder to Mailbox
Just wondering if it's possible to add a new folder eg Messages, to all
mailboxes without having to create the folder in outlook for each user.
...Change name of "Personal Folders" in Outlook 2003
How do I change the way a .PST file is displayed in
Outlook 2003? If I open a .PST file it always displays in
the folder list as "Personal Folders." So if I open
several .PST files, they all display as "Personal
Folders." I would like them to display as different,
descriptive names. (I.E. January, February, etc.) Please
Right click the root of the folderset-> Properties-> button Advanced-> field
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office XP CD slipst...