Formatting Lost in Excel 2007
I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.
We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no f...Printing WORD docs from a form
I have a button on a form and I want it to print a Word mail merge document
that contains data from the database that is linked to my application.
I'm using the following code but always get a 5922 error - Word can't
open the source... All variable names contain valid data, so that's NOT
.Visible = True
.MainDocumentType = wdFormLetters
strConnection = "DSN=MS Access Databases;" _
& "DB...problem with BOLD. ITALIC...using Word as editor
I compose a msg using Outlook. Word is the editor. I set a word in bold
ot italic. I send msg to myselg, reading in Outlook. The bold or italic
is gone. What to do?
Are you sending the message as text only? If so all formatting will
disappear. If you want to retain your formatting you'll need to send your
messages as HTML. You can check this in your Outlook options.
Martin Sketchley | www.msketchley.pwp.blueyonder.co.uk
(remove EGGBEANSANDSPAM to reply by e-mail)
...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
When I click the black plus mark to autofill a column, instead o
calculating the formula that I entered in the first cell, it repeat
the same answer as in the first cell. How to avoid this?
should I try reinstalling excel software?
Sometimes, I get correct answers without problems. If this becomes
problem if we employ the whole excel sheet? Once I used all columns an
about 100 rows. After that, I have this problem.
Let us say, that we need to multiply the first 2 columns. the correc
answer needed is in the 3rd col. and the wrong a...Not enough memory error trying to open a Word X file
Operating System: Mac OS X 10.6 (Snow Leopard)
Error message: "There is not enough memory or disk space available to complete the operation" when trying to open a Word X file in Office 2008 in Leopard or Snow Leopard on iMac that works fine in Word X despite resaving a new version. Any tips?
Not enough information to answer.
Check that OS X and Office 2008 have the latest updates applied.
Use Disk Utility to Repair Permissions.
Check the access your user ID has to the system Temporary folder (don't
worry about this if you ar...List of CRM tables?
I'm just starting out altering some SQL queries in excel to make the reports
more relevant and find myself wanting to pull data from two tables. Does
anybody know where there is a list of tables for reference of failing that,
which table the property opportunity.partneridname sits in?
For opportunity, you can look into opportunitybase and
opportunitybaseextension table. But you can use the view
Hope this helps.
Crowe Chizek and Company
On Feb 22, 12:23 pm, "Dempsey J" <xfo...@hotmail.com&g...Upsize table to SQL2K
I'm upsizing the BE of an A97 DB to SQL2K. One of the tables which appears
to have upsized correctly, i.e., the text field sizes are the same as they
were in the original DB, is giving me an error when I open the linked table
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. (Error 3163)"
When I open the table in Design view in Access, all of the text fields are
set to a length of 255. But in the original table, *most* of the text fields
were set to a length of 50. I've determined the offending field is...Excel protection
I'm trying to protect a sheet but let users put info into some cells.
I have tried "tools, protection, allow users..." stuff to select the cells I
want them to have access to. Then protected the sheet.
However when I try it out, I can only access 1 cell - not the all of the
ranges I selected.
I'm assuming I'm missing something out (or don't have a clue what I'm
before you protect the sheet select the cells which should be
accessible and goto 'Format - Cells - Protection' and uncheck 'Locked'
After ...Cannot upgrade to Word 2007 from Word 2002 as word crashes when tr
We have a word add in that programatically inserts an auto text table then
adds rows to it. This works ok in Word 2002 but occasionally crashes in Word
2007 - this is not a consistent crash when we carry out the same operation it
happens in no specific sequence. The only place we are able to track it down
to is the auto text table inserting rows. Word itself is crashing.
We are using COM AddIn written in VB6.
Does anyone know of any key differences/issues between Word 2002 and Word
2007 that could cause such an error.
Or is there a better way to attach a debugger/word debugg...Word 2007 TOC Not saving settings...
When I use Word 2007 TOC, and I want to edit an existing TOC layout, etc. It
wont remember my settings.
I go to
Table of Contents
Insert Table of Contents
Then I make my chnages here, such as changing the levels of the various
styles and how they show up
Then I select OK, the TOC is created..
I then decide I don't like the changes I made, or I need to include another
So I go to
Table of Contents
Insert Table of Contents
The changes I made are no where to be seen. I have to start over from
What am I doing wrong,...Macro to split the contents in a single cell separated by "," into next cell in that column
I have sheet 1:
column A column B columnC
WR# Phase SP#
Row2 60625 1-0110 60625RB1,60625NS1,60625GW1,60625BB1
Expected Output on clicking a button:
column A column B columnC
WR# Phase SP#
Row2 60625 1-0110 60625RB1
Is there a way to split the contents in cell C2 separated by comma (,)
and place it on next cell in column C itself?
Ple...Encoded Word Documents
We have recently purchased a new pc with windows 7 and have installed the
Microsoft Office software however when I got to open a PDF or word document
from a webpage a file conversion pop up box comes up and asks for me to
select the encoding that makes the document readable but none of them do.
even the windows default doesn't work......
You cannot open a pdf in Word. You need Adobe Reader.
What you're downloading from a web page probably isn't a Word
On May 27, 4:25=A0pm, Newuser <Newu...@discussions.microsoft.com> wrote:
> We have rece...Bulk E-mail with Non-Word Attachment
I need to be able to send a bulk e-mail (not from a template) with
attachments of a number of different document types to a group of contacts
(could be from a Saved View or Marketing List). Direct E-mail, Quick
Campaigns and Mail Merge do not seem to be able to do this. Is there another
Take a look at this blog
On May 16, 11:57 pm, DStella <DSte...@discussions.microsoft.com>
> I need to be able to send a bulk e-mail (not from a tem...How do I make my ERDs more automatic?
I am currently working on finding a way to automize VISIO. What I mean by
this is that I want to find a way to create some sort of database that is
connected to more than one Entity Relationship Diagram and, when I make a
change on an object on the database, I want that change to be reflected in
all ERDs that contain that particular object. These changes would be things
such as font, color, relations to other objects, etc.
Is there any way to do this? I only have basic computer skills so I need
Content-Type: te...Referencing other Office programs in a Excel VBA App
I din't like the way my previous post sounded, so i'm reposting...
My Excel VBA programming is decent enough when I'm only working with
However, I'm trying to expand my knowledge base and frequently I wish
I could better interact with other Office programs, such as Outlook,
in my Excel VBA apps.
To better illustrate my question, here's a piece of code that works
great (it populates a user form list with Outlook addresses) but I
don't fully understand.
Private Sub UserForm_Activate()
Dim x As Integer
Set objOL = CreateObject("...Help please
When running excel (and word). A cell will suddenly fill with a series of dots
and then random words like this:
...............he man place ther world
Does anyone recognise this?I've just installed Norton Pro and it hasn't found
any viruses. Surely though I have one. Can any one help?
Perhaps Speech Recognition is turned on. It might make text appear
Choose Tools>Speech>Speech Recognition
(if it had a check mark, it was turned on)
> When running excel (and word). A cell will suddenly fill with a series of dots
> and then ...Word Wrap: Where is it in Word 2007?
I have Googled and Googled and cannot find any page that tells me where
Word Wrap is. For such a basic feature you'd think it would be under
On Mon, 18 Jan 2010 18:55:28 -0600, "Gary Gary" <firstname.lastname@example.org>
>I have Googled and Googled and cannot find any page that tells me where
>Word Wrap is. For such a basic feature you'd think it would be under
The reason you aren't finding anything is that word wrap is automatic
in Word unless you turn it off, or possibly if something is broken.
Wha...Does Office 2003 Pro Excel have auto-save?
I am trying to set up Auto save in Excel 2003 Pro. I found auto recovery but
that is not what I am looking for. I think it may be an add-in.
ehop, From a previous post by Dave Peterson:
If you're running xl2k or earlier, install the autosave addin via
windows|Start button|settings|control panel|Add or remove programs
If you're running xl2002+, then if you can find a copy of the autosave addin
from an earlier version, it should work ok.
But xl2002+ has something called autorecovery. It's not the same as
but will allow you to recover files if excel/windows c...Where are my saved word?
I open the attachment directly, it is .doc and edit it in a loong time, what
I ask is when I press save button and it show nothing so I think it succes.
And I close it!! I can't find it now, could you help me ????? Thanks!
It is gone. When editing an attachment, you /must/ save it to your HDD
first, edit it and then reattach it.
Imperial Beach, CA
"smezsc" <email@example.com> wrote in message
>I open the attachment dire...maximum rows limitation in an access 97 table
we have an access97 db which has 32405 rows, is there such
a limit of 32700 rows in access 97 and if there is, can
this be rosolved by upgrading to Access 2000 or higher.
> is there such
> a limit of 32700 rows in access 97
No, the limit is that the database cannot be larger than 1GB. Check out
other specifications in Access Help, using "specifications" as a search
criterin in the Search Wizard.
"GM" <firstname.lastname@example.org> wrote in message
>...Automatically send out of office reply based on "show time as" sta
Can you set Outlook 2007 to automatically send out of office replies if you
have appointments that show your time as "Out of Office"?
"CaroleCarlo" <CaroleCarlo@discussions.microsoft.com> wrote in message
> Can you set Outlook 2007 to automatically send out of office replies if you
> have appointments that show your time as "Out of Office"?
If you're using Exchange 2007 as the backend, you can specify start and end
times for when the OO messages will be sent, but it isn't...Getting Excel to return Hiragana using code/char functions
I have a Japanese computer which does this perfectly, but when I tried to use
the worksheet on an English computer with Japanese language enabled, it only
came up with errors. The code it was returning for the Japanese characters
was much to low & putting in higher codes meant it didn`t recognise it.
What can I do to make it work?
...word 2002 compatibility with Windows 7
My niece is handicapped and her new computer has Office 2007 on it. She
would like me to install word 2002 on her Inspiron 546. Is this possible?
Yes, if it is licensed for another computer. If it is an OEM version, it
cannot be installed on any but the system with which it was sold.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sharon F" <SharonF@discussions.microsoft.com> wrote in message
> My niece is handicapped and her new computer ...Scenario Pivot Table[Urgent]
will like to ask for help on excel scenario pivot table. I try to
use the data from another spreadsheet and using the tools->scenario to
create the scenario pivot table. But when i tried to refresh the data ,
the 'refresh data' is disabled and i'm not too sure why. Any idea??
Does scenario pivot table allows us to refresh data ??
Message posted from http://www.ExcelForum.com/