Office XP SP3 interfering w/ Excel
I tried installing Office XP service pack 3, but, like many other people, I
don't have the Microsoft Office CD to insert when prompted. I figured I
wouldn't install this update and ignore it. However, I just tried to open
Excel to work on something and I received a message that said Windows in
trying to update Microsoft Office with Front Page and I need to insert the CD
(which I don't have). It also says I could browse for the file 'PROPLUS.MSI'
(which I can't find on my computer). I can't open Excel, but all the other
Microsoft Office Applications work j...XML Source Menu Item disabled?? File version??
My XML Source Menu Item is disabled (aka greyed-out). Why?
I have a workbook with multi-worksheets and I want to enable a conversion to
XML, I'm trying to follow the documentation here, but it's poorly organized
and more poorly written (IMHO).. I can't find anything which tells me why the
menu item would be disabled. The version is Office 2003 Pro and (clearly)
the capability is there, I can see the "XML Source" item.
I did a quick test and if I make a brand new file, I have the XML Source
option so that means means this is a file version issue?. I know this
wo...Problems calculating a converted html table to Excel XP (2002)
I have a generated report off the web that must be converted into Excel. When the report comes up initially it is in a .asp format. I save the report off the web in HTML format. Then open excel, then go to file -> open and browse for the file that I just saved.
The report opens fine with all data showing up as is. However when I try to go and calculate a column of numbers, the answer that I get is 0. So if I go and add up say this list of numbers which is : 5, 7, and 8. The sum should be 20. Instead I get 0 everytime. I have tried to format the cells to be numbers instead of gen...Vista keeps chainging my folder view
I go into a folder and get the following colums
Album Artist, Genre, #, Rating. I don't want any of this rubbish. I
only want date Modified which is missing. I remove this and put in
Date Modified. Next time I go to my PC they are back again and Date
Modified is gone WHY WHY WHY.
> I go into a folder and get the following colums
> Album Artist, Genre, #, Rating. I don't want any of this rubbish. I
> only want date Modified which is missing. I remove this and put in
> Date Modified. Next time I go to my PC they are back again and Date
> M...Problem Importing a TXT File
I have a workbook named 05-03-31. It contains information for the first
quarter of this year. Sheet 1 references cells on Sheet 2. Sheet 2 was
created by importing a TXT file. I thought I had accomplished something
wonderful at that time.
I now have a new TXT file with second quarter data. I opened the first
quarter workbook, 05-03-31 and saved it as 05-06-30, so now I have a
second quarter workbook. When I Import the second quarter TXT file into
the second quarter workbook it creates a Sheet 3. On Sheet 1 can I
globally change all the references to Sheet 2 to Sheet 3?
I tried deleting Sheet 2...deleted log files
Exchange 5.5, the antivirus program deleted a log file, eseutil and isinteg
result in JET errors. Is there anything I can do but restore?
are you sure it deleted it, or did it move it to a quarantine location? if
it deleted it, restore, with all the log files you do have, is your only
option...make certain to first exclude all Exchange folders from any
file-level AV scanning...
Susan Conkey [MVP]
"dlw" <firstname.lastname@example.org> wrote in message
> Exchange 5.5, the antivirus program deleted a log file...Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that
link to a file on our server. I am needing to test to see if the file exists
and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? I am very basic when it comes to VBA and any help would
be greatly appreciated.
...APPLICATION HANG windows XP
My PC had been running great for some time then I started to get the odd
"application hang" mainly when updates for my Avast security system were
It now "appplication hangs" on a regular basis mainly when the Avast updates
are occuring but sometimes on it's own, even my Outlook has had the
Contact Avast Support.
> My PC had been running great for some time then I started to get the odd
> "application hang&q...Excel crashes while opening excel file imbeddied with macros
This is the similar problem as mentioned by Delbert on 12/12/2005 that
whenever they open a particular Excel file, it gives them a "Send Report
Error." Weird thing
about it is it doesnt happen in all other Excel files, only happens to this
file when saving as usual and trying to reopen it shortly after that. It
happens on my machine and my friend working on the same file also.
Office 2003 SP2
Files are saved in local drive
Files are around 12MB size (varies)
Files have Macros imbedded
Files have links
While opening, the dialogue box appears twice, asking...Script to backup and rename excel files...
I plan to use a row delete script (I have this already) to get rid of
old data here at work. Before I run this though (I will be running it
fairly frequently) I thought I should backup the file I am working on.
Is it possible to write a script which creates a backup of the current
Excel file I am working on, without changing the filename of the 'live'
workbook, and which names the backup file with the time and date so it
is both unique and also searchable (EG 03122003-1645.xls or similar) ?
Ideally I would combine the two scripts so that once the script is run
a backup is created an...using the Lotus 1-2-3 file import, numbers command in excel
how do i use the lotus 1-2-3 file import, number command in an excel
this command in lotus..allows me to just import numbers, no text is
imported..i do not want to import text...please advise..im trying to convert
a lotus spreadsheet to excel and i need to figure out how to do this in excel
...CVS file won't open in Excel 97, Help Please!
I'm new at this so please bear with me. I am trying to open a CVS
attachment. The attachment contains a spreadsheet with imported tab
delimited files.The attachment automatically opens my Excel program. (I have
tried to save the file and open but that doesn't work either). When the
program tries to open I get the error message: SYLK: File format is not valid
My excel program is Excel 97 Any help would be greatly appreciated.
This was posted by Myrna Larson:
>From - Wed Apr 12 17:18:13 2000
From: Myrna Larson <email@example.com>
Subject: Re: file form...write Avi/wmv file using bmp images
How to write Avi/wmv file using bmp images
I would think you'd want some sort of authoring package. Do you just want
to show them one after another? If so you may be able to use something like:
But, if you want to do anything fancy you'll want something like Premiere so
you can lay out the timeline.
"Unknown" <firstname.lastname@example.org> wrote in message
> How to write Avi/wmv file using bmp images
...Copied text from Notepad disappears when pasted to Outlook XP
This seems to be a recurring but intermittent problem.
...Is there a limit to the number of worksheets in an excel file?
I have an excel file with about 150 worksheets. It will continue to grow.
Is there a limit to the size of this file or can I just keep adding
worksheets (they are inter-related with VLOOKUP functions).
Per the XL help file, the no. of worksheets is only
limited by memory.
>I have an excel file with about 150 worksheets. It will
continue to grow.
>Is there a limit to the size of this file or can I just
>worksheets (they are inter-related with VLOOKUP
...file with udf extension
I have a file with a udf extension. When I searched the several sites said
that it was related to excel, so I opened it with excel. When opened, it is
incomprehensible letters and symbols. Is there a way to convert it so that
it is readabl?
Microsoft MVP Excel
"Ruth" <Ruth@discussions.microsoft.com> wrote...Excel 2007 & XP/Vista
I hope this is the right newsgroup for this posting, my apologies if not.
If I open a workbook in Vista (which also loads Common Macros.xlsm via
XLSTART) and then open another workbook this also opens the same instance of
Excel. However, if I then try open a workbook in an email attachment
another instance of Excel loads and I get the message "File in Use - Common
Macros.xlsm is locked for editing" and I am given the option to Open Read
Only, Notify or cancel.
In my XP installation everything opens within the one instance of Excel
without any problems.
Is there anything tha...Open Quark files in Publisher??
Is there any possible way to open a Quark file in
Hi MarkG (email@example.com),
in the newsgroups
|| Is there any possible way to open a Quark file in
Nope. You would have to:
1. Attempt to use a copy/paste or drag/drop
2. Export the Quark pages as images supported by Publisher and insert them
3. Export the Quark publication as a Word/RTF/Text item (less the images)
and import the text only into Publisher
4. Export the Quark publication as a PDF, the go to ScanSoft.com and get the
PDF software for Word/Publisher that allows you to import PDF...split massive xml file
I have an xml file (sample below) that is massive. hundreds of megs maybe
thousands. I need to split it up into multiple files so each file gets a
copy of the header element and sub elements and 1 detail element. There
will be 1 file created for each detail element. Any tips how to do this?
Can I get away with not loading the whole file into memory at one time?
"Jeremy" <firstname.lastname@example.org> wrote in message
news:%23oCR4hcsHHA.1208@TK2MSFTNGP03.phx.gbl....joining up files to one database
i got a few files i want to join to gether to make one file, so when i click
it, all the tabs are at the bottom of the page?
hope you understand that
cheers for the help
You'll need to do a Move (Edit, Move or Copy Worksheet) to move each sheet
(or a copy of) into a common workbook. Then save that. No magic button.
Shortcut: Right click a worksheet tab -- Move or copy worksheet is there
too. Or you can tile (Window, Arrange) the two workbooks (get them both on
the screen simultaneously), and drag the tab from one workbook to the other.
Hold the control to copy instead of m...Problem with Outlook 2003 BCM and offline files
I have a client with SBS 2003 and Outlook 2003. Whenever he logs off if his
LAN workstation, he gets an error stating "Offline files (\\server\Users)
Unable to make 'Contact Management database .MDB available offline on
(UNC to his My Docs). Files of this type cannot be made available offline."
As a side note, has anyone had trouble with Google Groups searches lately,
say in the last week? I can search for items inside quotation marks such as
"files of this type cannot be made available offline" and I get few hits,
sometimes none. If I search without q...number of fields exceeds 256 when importing from a dbf file
I'm having a small problem with importing some old data from a FileMaker Pro
database. According to what I found out in the groups archive the best bet is
to convert it to a dbf file and then import it. However, I the number of
fields in the dbf file exceeds 256, so the import wizard truncates the import
at field number 256.
I would now want to spread the data over two sheets. However, in the process
of converting it to a dbf, quite a few of the field names get truncated and
therefore have the same name, so I can't use SQL to retrieve them. My
question is: what i...How Do I Delete My Local .PST Calendar?
How do I delete the calendar in my local .pst file?
When I create new .pst files, there is no calendar in it. But if I then
add a calendar to this .pst file, it screws up which caldendar my
meeting requests go into.
So I would like to delete the local calendar and just keep the service
Ernest Maw wrote:
> How do I delete the calendar in my local .pst file?
> When I create new .pst files, there is no calendar in it. But if I
> then add a calendar to this .pst file, it screws up which caldendar my
> meeting requests go into.
> So I would like to delete...Exchange mailbox recovery using Exchange DB files
I've shifted my Exchange 2003 machine to a new machine configured it and
created all user accounts/mailboxes same as in old Exchange server and
everything is working.
I've all the Exchange DB files from old machine HDD i.e. .edb, .stm,
..log files as it is.
But I don't have any type of backup using backup utility, but I have copy of
old Exchange files.
How can I transfer mailboxes/mails from old machine to new one.
I already studied Microsoft's Exchange 2003 Disaster Recovery Guide, and KB
article "Offline Backup and Restoration Procedures for Exchange" ...Excel data file format
How can I save a data set in *.xls format to *.asc, *.bin, *.wav,...
A macro like this will do
Don't expect too much from the orchestration though ...
HTH. Best wishes Harald
"Wordgeek" <Wordgeek@discussions.microsoft.com> skrev i melding
> How can I save a data set in *.xls format to *.asc, *.bin, *.wav,...
"Wordgeek" <Wordgeek@discussions.microsoft.com> wrote in message