"Too many different cell formats" error
Receiving this pop up error message when opening a .xls
file. File will not open. Any suggestions on how to fix
and save file?
XL: Error Message: Too Many Different Cell Formats
David McRitchie posted this
Leo Heuser posted a macro 2001-05-06 in programming as a very major revision of the macro in the eee007 article.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Lorena" <email@example.com...file handling with 2002
I am having a very difficult time with 2002 and making web
pages. I have read through Mr. Bartosik's site and I still
don't understand why there are all these wierd files Pub
creates. Is there anything out there that has a step by
step help guide for web publishing for PUB 2002? Thank you!
Have a look here and see if it helps you:
...Using mouse wheel to scroll drop down
How can I use my mouse wheel to scroll down a drop down list?
...Can Grow property
I know when you set the Can Grow property of a text field, the field will
grow causing the record to expand, when there is much data for the default
setting of the text box.
Is it possible to make the other fields in each record expand to the same
height as the largest field of that record? If you don't have borders
around the fields it is not a problem, but if you was to make the report
look like a table in a Word document by aligning the text boxes and putting
a border around them, the fields are not the same size.
Not putting borders around the text boxes and using a horizontal...continually getting send/receive errors using outlook 2002
Does anyone know why I am continually getting send/receive errors when trying
to send an e-mail. I can receive e-mails from virtually anybody that is not
blocked by Norton Anti-Spam(Norton Internet Security 2005). My account is a
pop3 account with the 'Orange' mobile phone network, therefore it has an
'@orange.net' address. I have tried 'repairing' outlook from add/remove
programs - this did not fix the problem. Neither did uninstalling and
re-installing (also from add/remove programs) this time it only allowed me to
send a test e-mail to my '@aol.com' ad...How to modify specific lines in a .ini file?
When writing multiple values to a .ini file I'm familiar with the
following basic code:
Open "c:\my.ini" For Output As #1
Print #1, "1"
Print #1, "2"
Print #1, "3"
Is there a way to modify/write values to specific lines only, for
example modifying the "2" value on line 2 to "5", without overwriting
the other lines with their unchanged values?
Thanks for any feedback!
You basically need to open the file and read the file until you get to
the specific row you are looking for then writ...how to recover the file which was not saved? #2
Operating System: Mac OS X 10.5 (Leopard)
accidentally closed the word file which i never saved it. how can I recover it?
On 11/4/09 5:37 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> accidentally closed the word file which i never saved it. how can I recover
Time Machine is your only option. Sorry.
If the file was never saved to disk there is nothing to recover.
Time Machine doesn't store what existed only in RAM, nor does even the best
file...can I use Access for Stock Trading analysis?
Are there any Access Templates that I can use to do some Stock analysis,
scanning, and decision making for trading?
Have you tried a Google search?
"microsoft access" templates
I got a lot of hits, including...
Microsoft Access MVP
"Find a job that you love... and you'll never work a day in your life."
"Hambone" <Hambone@discussions.microsoft.com> wrote in message ...Setting up to use Gift Certificates?
We offer Gift Certificates, and people can use part of the certificate with
the rest being saved as store credit. How do I set this up? Is there
somewhere in the guides I should be looking?
Also, we deal with Purchase Orders a lot, is there somewhere I can look to
see about setting that up?
Use vouchers for your gift certificates. You will need to create a voucher
item to sell as the gift certificate, and then you also need a tender set up
to redeem them. Search help to get more information on setting them up. As
far as PO's go, you need to set reorder points for eac...Using SQL in MS Access 2000
I am trying to run some SQL script in MS Access 2000 for creating
query. But its not take 'IF' and 'ELSE' command. Can someone guide me
that how can I use IF and Else in MS Access 2000.
Muhammad Hasnain Raja
You can't use If and Else in Access SQL. However, the IIf function is the
IIf(expr, truepart, falsepart)
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<email@example.com> wrote in message
>I am trying to run some SQL script in MS ...use TAB-key in child windows
I have a dlg-based MFC application.
My main window has a listcontrol, a treecontrol and several child windows
(with the WS_CHILD style).
Depending on the selection in the listcontrol, one of the child windows is
shown on the main window.
The problem is I can't reach the controls on the child window using the
I can only change between the listcontrol and treecontrol on the main window
with the TAB-key.
Is there a solution for this ??
"Wes" <firstname.lastname@example.org> wrote in message
> I ha...many-to-many relationships by Graham Mandeno
Hi to all,
A couples of months ago I was looking for a good way to handle a many-
I finally found this sample db: http://www.accessmvp.com/KDSnell/SampleDBs.htm.
It's simply great! Unfortunately it doesn't work in my case because
instead of using just numeric ID to relate the table I'm make use of
In the previous:
Graham told me that there was a way to give to the sample db this...banners using a HP 990cse
I have been racking what little brain I have for many hours now, and I can't
for the life of me get a 8.5" x 6' banner to print. Does anyone know if
there are any conflicts with this printer ? I keep getting a message when I
go to print that says "publisher object to large to print
publisher may not be able to print all the objects in your publication do to
printer limitations. Try lowering the resolution of your printer using the
properties button on the print dialog box. To continue printing, click ok.
To cancel printing, click cancel." when I do either one I g...IE 8 displays nothing for a page with a high-order Unicode character
Below is a minimal file that IE fails to display:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
<p>Big Unicode ﺡ<br />0 items</p>
If I change the "0 items" to start with something non-numerical, such
as "A items" it displays OK. Similarly, changing the high value
Unicode char to something much lower and it al...can't open .jpg from outlook 2000 without saving first
We have a laptop running Windows XP SP1 with Office 2000
Premium SR1 installed, all patches up to date. When this
laptop receives an email message with a .jpg file
attached, we cannot double-click the attachment to open
it. We get the error message, "No file format
information can be found in the registry." When we
clicks OK, we get the message, "Unknown file format."
Microsoft Photo Editor opens, but nothing appears.
If we save the file to the desktop, it opens without any
problem, but uses the program Windows Picture and Fax
Viewer. When we go in to the Fol...Can I use Find and Replace all with Hyperlinks?
I am using Excel XP. I have a workbook with multiple worksheets. Can I use
find and replace to find an entry that appears on multiple sheets and replace
it with a hyperlink to another file?
...converting publisher file to a word document (part II)
I have the same question as "Ajoy." Does anyone know how
to convert a publisher file to a work document? Or, does
anyone know how to convert a publisher file to a PDF
file. Does that require specific software?
You can do a "save as" but you will lose the formatting. And several of us
know how to create .pdf files. And yes, it does require specific software. I
use Adobe Acrobat Standard but there are some other .pdf creating software
programs out there that are not as pricy. Sorry I don't have information on
the other programs.
"tearl" &...what addtinal port used in WLM14
I have company laptop installed Mcafee firewall and antivirus. I can use
WLM8.5 in the past without any problem. However, after mandatory upgraded to
WLM14, WLM always stop responding after a while. The reason could be some
ports are blocked in the firewall. Does anyone know which
additional/different ports are used by WLM14 comparing to WLM8.5?
The ports are identical. Messenger is designed to operate in environments with everything
blocked other than port 80 (http) and 443 (https). So, I really doubt this is the problem.
It could literall...2102 All Domain Controller Servers in use are not responding
Running Windows Server 2003 SP1. Exchange SP2 and IIS 6.0. This is
basically a single-server DC (with Exchange) pointing to itself for DNS and
running Active Directory. Concerning the below 2102 error for DSAccess,
this DC was actually up at the time of the error and is not very busy. I do
not understand why DSAccess would think it wasn't responding. Is there
somewhere I can go to check the DSAccess settings, for example, wait a
longer time before declaring a DC as not responding?
Event Type: Error
Event Source: MSExchangeDSAccess
Event Category: Topology
Event ID: 2...When forwarding an email how many recipients can I send it to?
I got an error response when I forwarded an email to many in my address book.
It said, something about too many recipients. How many is too many?
I set a 300 recipient limit to my Exchange users at work. This is set
at my server level.
Quote from http://office.microsoft.com/en-us/outlook/HA012002371033.aspx
Many e-mail service providers set limits for the number of names
that can be in the To, Cc, and Bcc fields in a message. For example,
your e-mail service provider may limit each message to a maximum
of 100 e-mail addresses. If these addresses can be distributed among
the To, Cc, and ...Using images in bar charts
I know there must be an easy way to do this... I need to
use an image of a thermometer, where the red bar in the
thermometer replaces the typical bar in the bar chart.
I've searched on Google, and found a couple of things, but
they're technically beyond my capability! I know you can
use a graphic in Excel, but doesn't the graphic end up
being distorted? I will continue experimenting and
searching for the right answer, but I thought I'd tap into
this community and see if I get an easy answer.
Try Pope's wonderful site. Search down the list and you will see his
t...Lost e-mails using outlook express
I'm using a computer which is connected to a network. I
lost my e-mails on one particular computer and then i'm
unable to access the lost e-mails from neither the same
computer or the other computers which are sharing my
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.as...Too many clicks! Available formats box
I have a client who is unhappy with the amount of clicks in Word 2007. One
particular frustration is the Insert Date and Time Available Formats box.
Is there anyway to get Word 2007 to just insert the default Date without the
additional steps of the format box? I know to the average person, it's not a
big deal but this user lives in a pressure cooker and needs the useability of
Word 2007 to make things faster, not slower.
Thanks for your suggestions!
Ask the client to add the Date & Time command to the Quick Access Toolbar
...question about mailbox.pst file
I recently got a new computer and transferred my Outlook mailbox.
All the mail folders were intact and everything worked fine except
that all my calendar notations were somehow lost in the shuffle. If
anyone has any clues about where they might have gone, I'd appreciate
A more vexing problem is that when I looked for the mailbox file in
the new computer today, I found that the last one was dated about ten
days ago, the day it was transferred to this computer. In the past, I
think Outlook undated this file whenever I closed the program. Can
someone tell me why this isn....def file library name
Hello fellow Newsgroupies!
With an MFC linked DLL the name of the library appears in the .def
Is there anyway of getting hold of that library name during runtime?
; example.def : Declares the module parameters for the DLL.
; Explicit exports can go here
ie: can I get hold of the 'EXAMPLE' string using an API function?
Many thanks in advance,
"Newsgroupie" <email@example.com> ha scritto nel messaggio