How to open Excel sheet with more than 64000 lines
I am using Office 2002, and have received Excel files with greater than 64000
line items. Is there a way , or an update, with Excel 2002 to open files this
You need to upgrade to Excel 2007.
> I am using Office 2002, and have received Excel files with greater than 64000
> line items. Is there a way , or an update, with Excel 2002 to open files this
Yes, but not more than 65536. For that you would need Excel 2007.
"mgoehring" <firstname.lastname@example.org> wrote in message
ne...Cannot delete subreport
I am using Access 2003 and have a report I did a while back with a simple
subreport. I want to remove the subreport but for the life of me can't figure
out how to do it. Any help would be greatly appreciated. Thanks.
When you say "remove the sub report", what do you mean? Do you want to
delete the entire subreport control containing the subreport, or do you want
to keep the control, but change the report contained in it?
The first is easy - select the control by clicking once on it once, then
For the second, click the control once, then set ...Adapting Pc word template to mac
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi all <br><br>I am trying to adapt a Pc word template for my mother. Its for formatting recipe text from Bigoven. I emailed the author and he said the menu buttons had VB functions for each action. <br><br>When installed on the mac, the buttons don't do anything :( I can probably get details on what they are supposed to do so how would I do the equivalent in Mac? <br><br>I have a PC but I can use a Macbook for testing. My mother has a new Mac :)
Unfortunately, Mac Word 2008 has /no supp...How to Recover Deleted Sent Mail?
While trying to delete very old "Sent" mail I seem to have deleted all
"Sent" mail. Is there a way of recovering this mail?
Have you closed Outlook since deleting the old sent mail?
Next time, archive the items you want removed from your active .pst file.
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
After furious head scratching, Sidney Friedman as...MLA Anthology Citation in Word 2007
Is it possible to use Word 2007's built-in citation feature to cite a work in
an anthology with the proper MLA formatting for a Works Cited list? This
should be formatted as follows: (1) author of the selected work, (2) title of
the selected work, (3) title of the anthology, (4) name of the editor
preceded by "Ed.", (5) publication details, and (6) the pages in the
anthology where the selection appears.
Again, my question is if there's a way to get all that information into the
Word 2007 citation formatting tool.
The answer is certainly yes.
The question o...Rule for Deleted Items
I am being told that there is a rule in place on my Exchange server that will
not empty the deleted items folder every 30 days for certain users in my
organization. I found a recipient policy in System Manager that says "Users
Excluded from Mailbox Cleanup" but it only shows 2 users and not the 3 I was
told about. But I have confirmed that the missing person has email in her
deleted items folder going back to 2005 so it must be working. Is there any
other location I should be looking? Also, we just had someone come in and
migrate our Exchange environment from 2000 to a new...Can't see pictures in Excel / Word
When I open Excel or Word documents with pictures in them I can't see them.
Also when I copy / paste a picture into a document I only see the picture
border and a small box with a red cross in it.
The only way to see those pictures is in Web page preview or going into
bitmap image object and selecting edit, but when done the image is gone again.
In options / view / picture placeholders is unchecked, drawings is checked.
So can you see the pictures in Publisher?
Have you checked out your graphics card driver?
Read the third FAQ here. It is Publisher specific but it is rel...cannot delete message from deleted items
I have a message in my deleted items folder that when
choosing delete opens the McAfee box warning of potential
virus and wants me to choose open or do not open, but will
not delete. I have tried choosing another file and
holding ctrl and choosing the file I want deleted and then
choosing delete, I have tried moving it to the desktop but
it will only copy there, I have tried every form of delete
possible. I need help. Anyone know how?
Can you empty the deleted items folder entirely? Or turn off the McAfee
scanning temporarily to see if it makes a difference?
Julie wr...Template connect to outlook 2007
I downloaded the template called "IT Team Workspace" from mircosoft website.
Everything is working well.
But I have a problem to connect the "Tasks" to MS outlook.
In the default sharepoint page, i can choose "connect to outlook" at action
tag. But i cannot find it at "IT Team Workspace" template.
Can anyone tell me how i can do it on ""IT Team Workspace" template?
By the way, i am using Sharepoint 3.0 and outlook 2007
> I downloaded the template ...I can not delete a duplicate personal folders list #2
amazing that there isn't an easy fix for this. The instructions provided
simply don't work ( tools-email accounts-view change email accounts-deliver
to new account-finish-close outlook and reopen ), and none of the other
offered explanations have worked either. As this is such a common problem;
why hasn't microsoft provided a very EASY fix? I am more confused ( and
frightened ) and don't want to make the problem worse!
Your profile is corrupt, probably based on an incorrect migration of your
Create a new mail profile and configure it to use your exi...Reserved words get 'redefined'
A couple of times I've 'redefined' reserved words such that I end up
corrupting my database (Access2K). For example, I set up a query and set a
field's name to 'DESCRIPTION'. From that point forward, Access thinks I'm
referring to the 'DESCRIPTION' as opposed to Description (as in MsgBox
Err.Desciption). I recover by going to my backup copy of my development
database and recreating anything that I've changed after confusing Access.
Does anyone know if, buried in the guts of the database, I can correct this
type of error? Perhaps in a ...Shape and lines magically changed color on class diagram?
Some of my classes and their connectors turned red by themselves. How
do I change them back? I've tried everything from fill, to line, to
format, everything with no success.
Thanks in advance.
The red line means that there is an error.
To get rid of it, highlight the shape, format line and set the line color to
black or any other color.
If it doesnt work, click on Window\Show Shapesheet.
Find the LineColor cell in the Line Format section and remove the "Guard"
"Adam Smith" <email@example.com> wrote in message
news:cd587e4c.04021313...Office 2007 Group
Is there an Office 2007 Group? is any one using office 2007?? I love
Howard Huntley <hhuntle...@comcast.net> wrote...
>Is there an Office 2007 Group? is any one using office 2007?? I love
Why would there need to be? The current set of groups seem to have
dealt adequately will all versions from at least Excel 5/95 through
For a newsreader
For web based
And there are plenty of us here who have 2007, for some time ...Project server 2007 Timesheet creation
We are using project server 2007. When create a new timehseet, we are
facing the following issues.
1. Sometimes the timesheet will be created with all the data filled with the
planned hours against the standard row.
1. If we try to add the a new line to the timesheet using Add Lines, it will
be added without project name and tasks.
Please help me to resolve the issues.
Are you getting add-lines dialog box when you try to add...if your able to
see then you shoud select the project task and say ok.hope this helps
...Retrieval of Deleted Items After Being Deleted from the Deleted Items File
I deleted a number of important emails from the deleted
items file in Outlook 2000. This may sound stupid, but I
completely emptied the deleted items file instead of
deleting them one by one. Pretty stupid, huh.
Anyone. Can they be retrieved?
Sorry for sending this again but I seem to be computer
illiterate and it has taken me some time to explain the
unless you use Exchange server with deleted retention enabled, you are most
likely out of luck, but you can try something that might help....
I am using Excel 2002. When I click on Tools->Macro->Macros... i see 2 macros. The problem I am having is that I can't delete these macros, the delete button to the right is grayed out. How can I delete these macros?
maybe the macros are protected. Try hitting ALT + F11 to open the VBA
editor and try to delete the macros / modules there
> I am using Excel 2002. When I click on Tools->Macro->Macros... i see
> 2 macros. The problem I am having is that I can't delete these
> macros, the delete button to ...contacts list for Outlook 2007
I am trying to get Outlook 2007 to use my Contacts list as an address book.
When I right click on properties, and go to the Outlook address book tab.
The box for "Show this folder for an email address book is not checked. The
item is greyed and will not allow me to check the box. I have multiple
folders and all have the same problem. This is a new install of Office 2007
ultimate. How do I increase Office functionality to allow me to change this
setting. I have already tried to uninstall and reinstall and using the
repair function, neither option works.
...Two Momey 2007 Issues/Suggestion
I recently upgraded to MS Money 2007 Deluxe from Money 2004 and found two
issues that MS has never seemed to resolve.
The first is the frequency that bills are set at in the Bill Minder. The
list of options in 2007 is still the same as in 2004. I would have figured
that MS would finally allow you to set custom recurrent times. For example,
I have a subscription that is billed every 3 weeks - not possible to do in
Second, is what I believe to be a bug that I found to be pretty prevalent,
but apparently has not been fixed. The issue that that when I am entering a
transaction and ...deleting email in outlook, freezes before i can delete
i have a file with pics that symetec scanner says is to large.
i can receieve email but cannot send any.
it freezes before i can delete and says non responding.
I want to re-raise the old issue of Fax numbers showing up in the Outlook
Address book when one is sending an email. I know that this can be stopped
by prepending the Contact's fax number with a letter so that Outlook doesn't
see it as a valid fax number and therefore doesn't list it. What's always
puzzled me, however, is that this fix doesn't work if the fax numbers are
changed using an export to CSV...Cannot load shared Microsoft word libraries
I cant open any of my office 2004 programs. The window popping up
files have been moved from the original location and I have to move
or reinstall them. This happened right after I did an update so I
messed it up. Does anyone know what I can do without reinstalling the
program? Thanks for any help
this is symptomatic of an update gone wrong. Try re-applying the updates,
and all should be well again.
On 30/11/07 7:16, in article
"firstname.lastname@example.org" <email@example.com> ...OK to delete Deleted Items folder?
I'm afraid I'll have to delete my Deleted Items folder in Outlook 2000.
When I try to empty the folder I get a "The messaging interfce has returned
an unknown error. If the problem persists Restart Outlook" message. Is it
possible to delete the entire folder and replace it with an empty new one?
Will it create any problems?
Not possible. Run scanpst.exe against your pst-file to scan it for errors
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Se...Access/Excel: Create multiple Lines/Column out of one mulit-line Column?
I spent a lot of time today searching for a response to my question but
I had unfortunately no success.
The problem is the following:
I have got an Access-table called Employee with an ID and one
corresponding Field/Column called comment. These comments are stupidly
multi-line (separated by a Return).
It's my aim to have access (he he, wordplay) to these two fields in
Excel whereas the field shouldn't be longer that 255 characters.
I considered three solutions:
The table could be changed after being exported to excel in the
following two ways:
- Multiple Comment Column...How to delete chart
I created a histogram and want to delete it. I select it and the faint double
border apperars. There are no square handles like in 2003. Then I press the
Delete key. The faint double border goes away replaced by a single thin black
border. The chart is still there and is not able to be selected at all.
I entered "delete chart" in the Excel Help window, and there was nothing at
all on deleting a chart. Ditto for "remove chart." I got no help searching on
the internet either.
I have Excel 2007 and Windows XP Professional
When the border changes, can you press Delete a...Manually linking items to contacts Activities tab in outlook 2007
I have email linked to those contacts i want to view past emails in their
"activities" tab. But i'm not seeing the option to link other items to a
contact (i dont have Business Contact Manager)....like an email or a note or
a task....i don't see an option in any toolbar to form a link...please help.
Did i find it maybe? do i r-click the message and choose "message options"
and then fill out "contact" field? i'm used to the lingo "link to" from
older versions of OL---this seems a bit time-consuming
> I ...Delete blank Last page
In a word document where the last page is blank due to editing or whatnot,
how do you get rid of the frigg' thing.
This is a Visio newsgroup - your question was about Word.
However, I have had this problem as you have.
Narrowing the margins and line spacing on the page previous
to the last may get rid of this annoying "blank" page for you.
- Jeff Chapman
"silkies" <firstname.lastname@example.org> wrote in message
> In a word document where the last page is blank due to editing or