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...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...Excel #122
How do I get the the last two zeros to appear in cell i.e 10.00
With the cell selected, press Ctrl-1 or choose Format | Cells from the menu
In the left panel of the 'Number" tab on the dialog box that's presented,
choose 'Number' and then, in the rihgt panel, select the # of decimals you
> How do I get the the last two zeros to appear in cell i.e 10.00
...Excel in multiple sessions
A collegue is attempting to access data using vlookup in a spreadsheet from a
second spreadsheet which is opened in a separate session on his workstation.
It appears that multiple sessions of excel can't 'see' each other. Collegue
needs to have multiple sessions as he uses lots of spreadsheets with LOTS of
formulas. Attempting to open these sheets in single session usually results
in crashes and lost work.
Does anyone out there know anything about this?
Using Excel 2000 on Windows 2000 Professional sp4.
=vlookup() worked ok for me--but by having the workbooks in separ...How to remove read only protection from a file?
Everytime I save text or photos to a cd rom (rw), it saves it as a read only
file which I can't manipulate. Why is this and how do I remove the read only
protection from the file? Please help. Thanks
I'm assuming you are trying to open and modify the file while it is still on
the CD. Which you can't do, how could you, it's not a hard-drive. Copy the
file off the CD onto your hard drive to modify the file.
As for removing file protection, right click file and select properties to
locate the file attributes.
oh btw this forum is for questions concerning the use of Micros...remove service release 1
I have a user who wants a special build for outlook, due
to some kind of integration problem with another app. Is
there a way to remove sr-1 from the installation of
You would have to reinstall Outlook/Office. There is no uninstall for SR-1.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> I have a user who wants a special build for outlook, due
> to some kind of integration problem ...How to set publisher 2007 as default program...
I have publisher 2007 and 2003 installed on my computer (my company wants to
keep the old version in case the new version doesnt work out).
Everytime I open one of my Publisher (.pub) files, it opens in Publisher
2003. My question is, how do I set all my .pub files to open in Publisher
2007 not 2003. I have searched high and low and cannot find an answer.
I have already attempted set the program default, but it does nothing. (I
Right-clicked, properties, Change Default program... Publisher 2007 is not
listed. I browsed for the .exe file for Publisher 2007 (which has the same
name as th...hOW TO USE eXCEL FUNCTION
SO THAT I AM ABLE TO UNDERSTAND IF SALARY OF EMPLOYEE LESS THEN 7500 AND
GRADE IS A THEN 10% OR GARDE IS B THEN 8% OR GRADE IS C THEN 6% OR NOINCREMENT
I think this is what you want
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest a...Excel 2003
Hi all Excel Gurus,
I need help. I have an excel workbook with a sheet called template and i
want to create a button to copy a selection of data which is B9:B34 and i
need it to paste the information to another excel workbook with a sheet
called data which will be A:AA and add each row when pressed. When the data
has been copied over i need it to close the data sheet.
Can someone help me please?
When you copy a range of cells you only have to specify in the
destination l;ocation the 1st cell of the range like I did below.
Private Sub CommandButton1_Click()
FName ...Excel 2003
When I click on the end of a formula in a cell, I usually get all the
associated cells highlighted with different coloured borders.
I have one workbook with several sheets where this no longer happens on
just one sheet.
Is there some option I need to turn on in the sheet to make the coloured
cell borders appear? Or might it be something to do with very recently
using automaic update to bring my Office 2003 up to date?
Any assistance much appreciated.
You should always get *exactly* the same actions if you would click in the
As far as having the cell itself h...MS Outlook 2007 SP2
Is MS OutlooK 2007 SP2 support for CRM4.0 Outlook client. In documentation it
is mentioned MS Office System SP1.
Please clarify if MS Office 2007 SP2 is supported.
The documentation was prepared before SP2 was available, but what they
describe are the minimum version and patch levels. Generally speaking, any
patch level above the documented minimum will be fine.
"mvj123" <firstname.lastname@example.org> wrote in message
> Is MS OutlooK 2007 SP2 support for CRM4.0 Outlook client. In documentatio...excel 2002 data filter
this is the case
if i have in column A data like this:
When i press select complete column A and then select DATA - FILTER -
ADVANCE FILTER - UNIQUE RECORDS ONLY i get folowing result:
this is not what i want. I want to get folowing result:
u see what i meen? Can u help please and thank you very much!!!
On Feb 14, 2:10=A0am, Ivanko <Iva...@discussions.microsoft.com> wrote:
> this is the case
> if i have in column A data lik...as400<iSeries db<ntWS<macro<excel tools
i have an inventory of appx 1000 serial numbers. using keystroke recording, i
can populate 2 - 6 fields on 4 green screens to complete a process on one
serial number. is there a way to tweak my macro to incrementally continue,
automatically, from a list stored in an excel workbook on the client? would
be very grateful for fresh ideas.
Show us your macro and some data details.
(remove nothere from the email address if mailing direct)
"ayeFayze" <ayeFayze@discussions.microsoft.com> wrote in message
...how I can insert date picker in excell template?
Maybe one of these will help:
...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...SQL Reports in Administration & Excel Crashing
I am using GP 10 and have recently deployed SQL Reporting Services reports in
Dynamics. I have a problem when I go to access the reports. In GP 10 after
going into Administration and Custom Reports, I get a message that Excel 2007
has crashed. I am not sure why since I am not trying to access Excel 2007 at
that time and do not have it open.
I realized that that is not an Excel forum, but hoping someone might know a
solution due to how Dynamics is relating to Excel in this area that would
cause this problem.
I had Excel problems that seem similar to your's. I had an Excel...How to get the Mainwindow of Excel via COM ?
I didnot found a methode in the Exel VBA-Documentation to get the MainWindow
of Excel. Now Im using CWnd::FindWindow("XLMAIN",NILL). But is not there a
I dont know if there is a function but that will be available thru the
Object Model of Excel if its exposed by it.
Ajay Kalra [MVP - VC++]
"Mark Henning" <email@example.com> wrote in message
> Hello there,
> I didnot found a methode in the Exel VBA-Documentation to get the
> of E...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
...Student Loans in Money 2007
I have four student loans all under one account with Sallie Mae. I've
entered them in Money separately because they are at differing interest
amounts - I make only one payment to Sallie Mae and they split it between the
loans. My problem is that I dont know how to apply the one payment to the
four accounts (in order to track).
You can't have one Loan Payment target four different Loan Accounts. It's
just a limitation. Not a great one. If I were designing it, it wouldn't have
this limitation, but there it is.
Assuming you want to track these as separate loans (and ...Project 2007
One of my students has some tasks which will be repeated at different points
during the project (Reoccurring task won't work in this case). Is there a way
to copy and paste his extensive note information without having to open the
Task Information window each time? Selecting the task row to copy and paste
won't bring over the notes.
In article <8FB23A12-C779-4370-9749-D9758403B352@microsoft.com>,
Mikel Anne <MikelAnne@discussions.microsoft.com> wrote:
> One of my students has some tasks which will be repeated at different points
> during the project (...making a primary key in excel
i would just like to know howq you can format a column so that it
automatically inserts an ID when i input a new record.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
your best bet is to have a formula such as =A1+1 in the cell A2, but you
would need to drag this formula down. If you don't want users to overtype
this, you'd need to lock it down and protect the sheet.
"electric_d" <electric_d.vqwbb@excelforum-nospam...Help needed in excel transpose #2
I need a macro to transpose data in the excel.The data that i have is
in the following format:
This is repeated in the next row and so on..
I need it in the following format
Summary Steps Expected Result Keywords
somedata 1)Some data Some data Some data
Summary Steps Expected Result Keywords
somedata 1)Some data Some data Some data
Note that th...How to set Read-Only Recommended as default save in Excel 2002?
How do I set Read-Only Recommended as default to save files in Excel 2002?
This is not a global option.
Must be done on each workbook.
One way around this is to open a new workbook then save as a Template with the
options you want.
Name the workbook BOOK and save as MS Excel Template(*.xlt)
Do not enter the extension, Excel will do that for you.
Store in your XLSTART folder and it will become the template for all workbooks
when opened via File>New
Note: this will not affect previously saved workbooks.
Gord Dibben Excel MVP
On Thu, 14 Apr 2005 14:11:01 -0700, "flyaj&q...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...