Excel File Corruption
I have a large excel spreadsheet (exceeding 5MB) that suddenly failed to
update cell references. Due to the amount of changes being made on this
particular day, I had put about three hours of work in ( all saved
periodically) when I realized that cells referring to other celss were not
updating when the values of the xource cells changes. I also discovered
that cell references had failed to update when rows were added above the
I work for a large international services firm, but our in-house tech group
had no answers, excpet to suggest closing everything, re-booting, and
reope...Unable to open Outlook2003. Error: MAPI unable loading msncon.dll
I am trying to set up Outlook 2003 on home computer but keep getting the
following message when trying to open application.
MAPI was unable to load the information service msncon.dll.
Since I am not open to open, I cannot get to the help feature.
Have you downloaded the latest MSN Connector from their site? Or, if not
using it, have you uninstalled it? Try opening Outlook in Safe mode
(start->run->outlook.exe /safe) and go into the Advanced options and uncheck
it from add-in manager or COM add-ins.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Excel in Office for Mac 2008 features
I've had Excel crash numerous times the first day using it. THe Auto Save feature does not seem to be working. Each time it crashes it brings back the old saved spreadsheet with none of the changes. Auto Save is set to 10 minutes and sometimes it had been hours and still reverted back to the old saved sheet and not the updated autosaved one.
In article <firstname.lastname@example.orgR9absDaxw>, Foosh@officeformac.com
> I've had Excel crash numerous times the first day using it. THe Auto Save
> feature does not seem to be working. Each time it crashes it brings back th...Word Wrapping in Excel
I am having trouble with Word Wrapping in Excel. It does not adjust th
row height properly. I have tried Format, Rows, AutoFit and it stil
Mandy11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1300
View this thread: http://www.excelforum.com/showthread.php?threadid=27632
do you experience this with merged cells. If yes->nothing you can
really do about this without using vBA
> I...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Horizontal line chart
I have prepared a bundle of column that has one XY scatter plot serie
It works great, updates with VBA, no problem.
Now I was asked to add one additional point in each serie to the char
with some calculations. Although looked to be be very easy job, it'
not, as the file get corrupted while modyfing the data source for thi
chart using the MS chart interface. I've tried to put the modificatio
into the command line and it works for the chart. Unfortunately it doe
not record while macro recoding ('Macro recording not possible' error
that is essential to update automatically t...Office 2007 Excel
Every time i open Excel 2007 i get the following; "The file you are trying to
open,'PDFMaker.OLDxla',is in a different format than specified by the file
extension. Verify that the file is not corrupted and is from a trusted source
before opening the file. Do you want to open the file now?" I pressed
CTRL+Shift+I and receive the folowing id 101786 however I could not find
anything relating to the above. As a note you have to press NO two times
before you can get into excel.
Hope I got this in the correct discution group.
If you're not using the pdfmaker.* addin, how...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...Multiplying in Excel
Why does excel and my calculator come up with different answer when
multiplying numbers with decimal points? Excel seems to be off by a couple
hundreths of a point.
On Thu, 3 Feb 2005 07:53:03 -0800, "albebach"
>Why does excel and my calculator come up with different answer when
>multiplying numbers with decimal points? Excel seems to be off by a couple
>hundreths of a point.
Hard to tell why you get the results you do when you post so little
The most likely answers have to do either with you not realiz...Excel
1. Look at a worksheet ; the range A1:A10 is filled with text data.
2. Enter into cell C1, = Countif(A1:A10,"<="&A1:A10) ; it works.
3. Then, the range B1:B10 is filled with text data.
4. Enter into cell C2, = Countif(A1:A10&B1:B10,"<="&A1:A10&B1:B10) ;
it does not work.
5. Please offer an explanation that it does work and then it does not
I'm having a bit of a hard time understanding what you're trying to do...
is functionally equivalent to
=COUNTIF(A1:A10,"...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...in excel formula the comma (,) is no longer accepted but the semi.
when entering formula in Excel the comma (,) is no longer accepted but the
semicolon (;) now has to be used.
Previous : =if(a2="Yes",a3+a4,b3+b4)
Now : =if(a2="Yes";a3+a4;b3+b4)
How do I change it back to using commas. I don't know how this has happened,
I just arrived at work one day and the changes has occured.
Not a 100% sure how well XL honors them, but check your Windows
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <5...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my
> s...Ideas for drag and drop, repositionble items
I have a design problem where I need a set of buttons/controls in a
horizontal line, and be able to pick one up and drag it in front of
another to alter the order (like grabbing a button on the quick launch
bar and moving it in front or behind of another, displaying a spacer
marker in the process). I want to do some fancy drawing on these
objects, and be able to zoom in/out so the objects increase/decrease
in horizontal size. So basically it's a horizontal set of zoomable
(horiz) buttons that can be selected, and/or dragged around within the
parent window so as to be placed before o...Excel Button Properties
Anyone know where to find the properties for the command button that is used
This is for Excel 2000.
In particular I am looking for a tooltip property but I would like a list of
all of them.
Click the design mode icon on the Control toolbox toolbar.
rightclick on the commandbutton and choose properties.
> Anyone know where to find the properties for the command button that is used
> on worksheets?
> This is for Excel 2000.
> In particular I am looking for a tooltip property but I would like a list of
>...how do i change excel into picture format
i am trying to change an excel documnt into a jpeg or other picture format
can anyone help me? i dont even know if its possible
Take a screenshot.
> i am trying to change an excel documnt into a jpeg or other picture format
> can anyone help me? i dont even know if its possible
Or just copy the cells you want to include in your jpeg and paste into Paint.
> i am trying to change an excel documnt into a jpeg or other picture format
> can anyone help me? i dont even know if its possible
Select the cell to be shown in pict...Unable to start POP3, NNTP, IMAP4...
I'm evaluating to install Exchange 2003. After the installation I find the said protocol haven't been started. I tried to start
them in "Servers --> Server Name --> Protocols" but no help.
Please comment.... Thanks!!
Windows 2003, Exchange 2003, Active Directory DC with all roles of FSMO as it's the first DC in the forest. Thank you very much!!
Are you boring? Let's come to talk together... ^^
Those services are disabled by default in Exchange 2003. Go to
Administrative Tools, Services and enable...Populating Excel from CSV
I need to know how to populate an Excel template with data from a
external CSV file. Let's say I have this nice pretty colourful templat
that is far more pleasing to the eye than the usual chunk of importe
CSV data, what are some methods to populate it with data from a CS
Any ideas or suggestions or redirections would be much appreciated.
Thanks in advance :
AJMorgan591's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2777
View this thread: http://www.ex...How do I convert Supercalc to Excel
I have data on disks that are in SuperCalc that I would like to convert to
Excel, but I don't know how to do that.
Excel can't open SuperCalc files. You'd have to get a copy of
SuperCalc and save the files from there in to a format that Excel
can read (e.g., text, CSV, SYLK, etc).
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Bean Counter" <Bean Counter@discussions.microsoft.com> wrote in
>I have data on disks that are in SuperCalc th...Importing an Excel file into Money
I do my banking with Smith Barney. Although I could
download directly into Money (or Quicken) there is a
monthly charge to do this. I don't want to use Money or
Quicken to pay my bills, simply to organize my finances
I am able to download my account data into Excel. Is
there anyway I can import from Excel into Money? I tried
doing this using the import feature, but nothing happened
when I selected the Excel file and clicked import (no
error messages or anything).
In microsoft.public.money, Cruzin wrote:
>I do my banking with Smith Barney. Although I could
>...Plotting data in Excel #2
Is it possible to generate a cell range mathmatically using formulas and
"Concatenate" in one reference cell, and then use the contents of the cell to
define the data range for an X-Y plot?
In other words, instead of manually selecting the data range to be plotted
using a pick box, I want the reference the contents of a cell that has
computed the data range.
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 p...Unable to conect
I have set up my email account to work with aol using the guidlines for
outlook 2002 but it is still unable to connect. Any suggestions? Thanks.
John <John@discussions.microsoft.com> wrote:
> I have set up my email account to work with aol using the guidlines
> for outlook 2002 but it is still unable to connect. Any suggestions?
Since you pay AOL for their service, my suggestion is to ask AOL.
...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...Excel vba autofilter code
I have some code to filter a result set to a list of unique names - is
there something I can add that will also remove 'blank' entries ?
Range("AP1:AP" & LastRowNewData).AdvancedFilter _
...I am unable to send e-mails -unable to download files from IMAP.
I am so frustrated with this
ajmtextiles <email@example.com> typed:
> Please help.
> I am so frustrated with this
I can understand why you might be frustrated, but you've provided no useful
information for anyone to go on, so I doubt anyone can help you. When you
post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent de...