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)
...where is that save data feature for backup?
On sql 2005, where is that console that allows me to save my data
to a directory for easy backup? If I remember correctly, I can set this
on a schedule too? I was shown this a few years back, and for
my life I can not remember where it was. :'[
ToddAndMargo (ToddAndMargo@invalid.com) writes:
> On sql 2005, where is that console that allows me to save my data
> to a directory for easy backup? If I remember correctly, I can set this
> on a schedule too? I was shown this a few years back, and for
> my life I can not remember where it ...Adjusting one data set based another
I'd like to compare two sets and report a result that shows how one data
set would plot if related to the other set (sorry, I know that's poorly
worded). Here's an example:
Sample #1 Sample #2
25% 0.26 25% 0.264
30% 0.31 30% 0.317
35% 0.36 35% 0.365
40% 0.41 40% 0.426
45% 0.45 45% 0.5
50% 0.51 50% 0.569
55% 0.56 55% 0.644
60% 0.62 60% 0.72
65% 0.69 65% 0.779
70% 0.75 70% 0.835
75% 0.84 75% 0.901
80% 0.93 80% 0.968
85% 1.03 85% 1.049
90% 1.12 90% 1.108
95% 1.24 95% 1.194
100% 1.4 100% 1.242
So, in the above data for example, at 50%, sample #1 reports 0.51 in
sa...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.
File|SaveAs|Tools|Ge...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...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...Repost: "Save target as..." option
When I used to use Outlook Express, I could right click on links (to PDFs,
pix, etc) in message bodies and select the option "Save target as...". This
option doesn't appear to be available for links in emails in Outlook 2003,
and I'd be grateful for advice on whether this is a feature of Outlook, or a
setting I need to change in the options somewhere.
It is a setting in the OS and not Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
...Money 2007 Premium Application Error
Hi, I started getting an application error while in Money and now can't get
into it at all. I get error message unknown software exception (0xc000000d)
occurred in the application at 0x7813e792. I've uninstalled the application
then reinstalled it using the CD an I get the error message. It occurs after
entering my passowrd when the Home page is displayed.
...Search and Replace: set user preference?
I use Find and Replace extensively; after the first use when I open the
F&R window the "Replace with" box is highlighted. I'd prefer the "Find
What" box to highlight each time I open the window.
Will Excel allow me to set that preference somewhere?
I don't think you can change this behavior--and I wouldn't think that a
workaround (doing a dummy find that replaces nothing with nothing) would be
> Excel 2003
> I use Find and Replace extensively; after the first use when I open the
&...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,...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...Outlook 2007 Export w/ Date
We have a need to print a list of e-mails from Outlook 2007, so we can make
comments on each of them. The export seemed to be a perfect fit for this,
because we could bring it into Excel, and type our notes. However the
export does not include the date field. That's crazy. That's one of the main
pieces. Is there any way at all to export this data and include the dates?
http://www.outlook-tips.net/howto/copy_data.htm - if you need the message
body, add the message field to the view and copy and paste. Note that it
works best if don't need the body - or at...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" <firstname.lastname@example.org> wrote in message
>I open the attachment dire...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...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" <email@example.com>
>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...DPM 2007 Rollup KB 979970 is now available
The latest DPM 2007 Rollup KB 979970 is now available for download at
The KB page is available http://support.microsoft.com/kb/979970
Praveen T [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights
...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...MS Pub 2007
I'm using MS Pub 2007 and have a question about HTML fragments.
can subscribe to my newsletter off my website (created with Pub). How
can I set up a "submit" button in my publication with the script?
Thanks for your help.
Inserted HTML code fragments will not work in an email message from
"geedc" <firstname.lastname@example.org> wrote in message
> I'm using MS Pub 2007 and have a question about HT...Word 2007--pesky black dotted line
I have this moderately thick, black, dotted line running between paragraphs
on my page. I have no idea how to get this thing to go away. Please, could
you tell me what to do to get rid of it?
Mary Sauer MVP
"John" <email@example.com> wrote in message
> I have this moderately thick, black, dotted line running between paragraphs on
> my p...Setting up hosted accounts in exchange 2003
We are trying to host another domain on our exchange server. We have
added the domain into the recipient policy and have our ISP pointing
all mail to our IP. Everything works fine for our main domain that we
The problem is that we can send to externally but we cannot receive
from the outside world. The error we receive when trying to send from
an external address is <our address >: Host or domain name not found.
service error for name=our address type=A: Host found but no
data record of requested type
The error on our server is MS Exchange Transport 7002
The error we rec...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 ...Outlook 2007 problems 03-08-10
When I run Outlook, the first thing I see is Outlook Today, which is good.
But I cannot see my calendar entries on it.
I have my work schedule, birthdays, public holidays all in separate
calendars in outlook, but none of them show up on outlook today at all, I've
search the net but cannot seem to find the answer
Are they all in subfolders of the default calendar or do you have anything
IN the default calendar folder?
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.officeforlawyers.com/out...my e-mail dose not work in office 2007
i am trying to e-mail from office 2007 i have to icon but when i click on it
nothing happens do i have to activate it
"glo" <firstname.lastname@example.org> wrote in message
>i am trying to e-mail from office 2007 i have to icon but when i click on
> nothing happens do i have to activate it
And your email client is?
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
See if your mail p...