I accidentaly deleted some folders from my E:drive. I realised what I had
done, opened the recycle bin, and restored them.
All Ok except for the E:Videos folder, which did not appear in the recycle
It's not a disaster, as I have the folder backed up, but I'm puzzled ?
Ideas pls ?
On 19/05/2010 15:15, KRK wrote:
> I accidentaly deleted some folders from my E:drive. I realised what I
> had done, opened the recycle bin, and restored them.
> All Ok except for the E:Videos folder, which did not appea...XP confusing Excel and Publisher
When I try to access the Excel Help files, XP tries to
install Publisher, then tells me I'm missing a PUB file.
If I try to close Installer with Task Manager, Excel
itself crashes. Help! Thanks
...Installing all excell functions ...
Any body nows how to let available all the functions (financial ones),I'm trying to use that formula to check the Yield to Maturity (YIELD) but is not working, I have re-instaled alredy, but is still not working, any Ideas?
It's VBA instrument???
As well as installing from the CDROM you need to select it using:
Tools > Addins
Check Analysis ToolPak
Thereafter the functions will be available every time you open Excel
as long as you don't de-select.
Norman Harker MVP (Excel)
"Oswald" <annimo@di...Sharing between spreadsheets
In Spreadsheet A I have a list of tasks and values next to
those tasks. In Spreadsheet B I have totals of the values
from Spreadsheet A.
If I have Spreadsheet B open at the same time as A and
change something in A, B is updated. If I close B, change
something in A and then try opening B again, all the
values will be stuffed up by however many rows were
I've tried locking the cells with $ and then again without
locking them. I've also tried going to the External Data
toolbar, but the only thing available is the 'Refresh All'
option which has no visibl...Outlook 2007 Missing Mail
I have an office where we are noticing that if we look in Vista Mail that MS
outlook 2007 has missed many emails. Program restarts and reboots don't seem
to correct the problem, and both programs are using the same IMAP settings.
Is there a "helpful" little option in Outlook that prevents it from looking a
all email receieved to an account? Does anyone else have the same problem?
are there any similarities between the ones it misses?
"nano" <email@example.com> wrote in message
news:DC22F7E7-ACB7-4824-A0A1-3329D3C622EA@microsoft.com.....Linking In Excel
I am linking from an Excel sheet to files which use other applications
and I want to change the application that these files open with. The
normal way of changing file associations does not work i.e. opening a
JPEG file with ACDsee as the default opens with "Microsoft Photo
Editor" through the Excel Link. Any Ideas? Solution to this would be
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
It is a Windows setting.
O...Missing Emails #2
From time to time my users report that so-and-so sent them an email but they
never got it. Last night my VP sent 2 emails from home and never got them.
1. We have Exchange 2000 server, all clients are Outlook
2. We have Symantec anti-virus for exchange server
now I have checked the following:
1. in the Exchange logs [reading them in Excel] I can see the 2 messages
arrive and seem to process normally -- HELO,MAIL, RCPT, DATA, QUIT are the 5
lines in the log; the datum on the HELO record says =+sccrmhc13.comcast.net.
the Quit record as cs-uri-query of 240.
2. I have searched through...Same Text on Multiple Worksheets
I need to enter text into certain fields on a worksheet and I want that text
to repeat automatically on other worksheets in the same workbook.
Cell references on the other worksheets are not the same as the original
You can use formulas that point to any cell on that original worksheet. It may
be a pain to set it up the first time, but once it's done, it's done.
can go in any sheet in any cell to retrieve the value from A1 on sheet1.
This is nice for titles.
But if you have a key unique value in a column, you m...Worksheet 250 too large with 5000 records?
We are seeing HQ Client having occassional trouble processing worksheets with
item counts in the neighborhood of 5000 records and above. This is only at
some store, occassionally, and without regard to connection type or speed.
Spreading the same content across multiple worksheets has been the fix to
This is a multi-part message in MIME format.
Your better off breaking it into smaller pieces and connecting more =
oft...Office 2000 Excel SP-3: Nasty intermittent bug during save.
The bug occurs in the following circumstances (although not every time).
1. Two files are open,
- a 'book4' type temporary file that I couldn't care less about.
- a rather large 10 sheet workbook that I've been working on.
2. I try to save the large file - instead
- the _temporary file_ is saved _over_ the large file on the disk.
- an error message is displayed saying the file has been saved but
that it is out of memory and had to close it.
- the temporary file is displayed.
3. Generally the large file disappears from the task bar.
4. If the large file doesn't disppea...Missing Folders after Sync
After connecting to the Exchange Server, several folders
that were created to store messages disappeared. They are
not on the server or any .pst file in my system.
Any idea how I can find them and restore?
Where were they located?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Marc" <firstname.lastname@example.org> wrote in message
> After connecting to the Exchange Server, several folders
> that were c...Bin Transfer Entry window missing
I am trying to enable multiple bins in GP 9.0 in the sample company.
I clicked on Multiple Bins, ran reconcile and checklinks, but I cannot
find the window to do a Bin Transfer Entry (Bin to Bin Transfer). I
am looking under Transactions >> Inventory, and "transaction entry" is
listed, as well as "Transfer Entry", as well as several other options,
however, "Bin Transfer Entry" is not listed. Does anyone know how I
can go about getting that option?
Enter a transfer entry from site A to site A and complete the line.
Richard L. Whaley
Author...Missing Fonts in Word Art
When I open up a Pub 2003 document on a computer that did not create the
document, the fonts that are missing on the current computer are listed as
the document is opened. These missing fonts are only those used in text
boxes, not the fonts used in word art. The word art just defaults to an
arial font. When I open the "edit text" menu in word art, the font box is
Do I have a setting wrong or is this just how it is with Publisher 2003?
> When I open up a Pub 2003 document on a computer ...Free Excel plug in for 3D scatter charts (X, Y, and Z)?
Does anyone know of a free plug in for Excel that creates 3D scatter plots
It isn't a ready to use plug in, but Andy Pope shows how to simulate a
3D scatter chart in the free sample on his web site:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> Does anyone know of a free plug in for Excel that creates 3D scatter plots?
...How can I share Outlook
I have 2 networked computers but do not use Network Server.
How can the Outlook functions be shared?
See http://office.microsoft.com/en-us/assistance/HA011477571033.aspx for an
article by Outlook MVP Eric Legault on various ways to share Outlook data.
YOu'll also find a list of third-party sharing tools and other information
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"john petty" <j...Missing Message Text
Yesterday, Windows Live Mail started doing something strange. I type the
message, then press "send." The first lines of the message somehow are
removed. The recipient sees only part of the message and only part of the
message shows up in my sent messages folder. The first part is just gone.
Seems to be only on messages that are replies. Any ideas on what the problem
is, or how to correct it, would be appreciated.
Never heard of this . . . . . are you on version 14.0.8089.0726?
Regardless, try a reinstallation.
"DeVere" <DeVere@discussions.microsoft...Is there a "Go To > Links" command hidden away anywhere in Excel 9
Im frustrated by getting the automatic update prompt everytime i open a
In "Edit > Links", I can see what external workbook the reference is to, but
not what cell it is from in my workbook.
Any help would be hugely appreciated!
for an addin see:
"Chris Vrionides" wrote:
> Im frustrated by getting the automatic update prompt everytime i open a
> particular workbook.
> In "Edit > Links", I can see what external workbook the reference is to, but
> no...user's messages-profile missing when connected to new domain-help
Please be patient as the story is long:
I migrated my users from a workgroup to a Client/Server
network about a month ago. A network using Windows 2000
active Directory. All the clients workstations are
Wondows 2000 professional. Before migration, I exported
the emails, etc. to a .pst file and after migration
imported the same file and all was fine. Last over the
weekend our Active Directory server crashed by a Virus
supposedly and we had to rebuil the servers, and couldn't
have the users logon on to the network to the
export/import scenarion again. After the server were
re...Excel 2000 SP3 printing issue: text is either rotated (each individual letter) or small or not even there
This is regarding Excel 2000 running on a Windows 2000 Professional system.
One of my users is having an issue printing from Excel. The document
appears to be quite basic, but when she prints it to a color printer (HP CLJ
5500 PS) the letters in the black text are individually rotated 90 degrees,
although the string of characters remains horizontal. This does not affect
the text that is colored red, only the black text, strangely not all of it,
like there is a heading on the chart, and that is fine, but doesn't appear
to be any different than the rest of the text. When she prints to a B...Missing Sata Sources
When I click Data, Get External Data, New Database Query..., there are
no data sources listed in the Database list under <New Data Source>.
Even the defaults e.g. dBase Files, Microsoft Access Database, Excel
Files, etc are not listed.
I am using Windows XP Professional with Office 2000.
How can I fix this?
...export query into excel
I would like to export certain feilds in a query into excel. However I want
Full_Name to go in cell A3. I have about 12 more feilds that I would like
in certain cells. Could someone please help me. I would activate all this
with a command button to open up a specified excel spreadsheet and go to a
Something like this ought to work for you.
Arvin Meyer, MCP, MVP
"Chey" <Chey@discussions.microsoft.com> w...What am I missing?
Have PC. Onlyprofile on it is administrator.Me.
What am I missing on System Restore. There are partitions that I do not
need,or want, for System restore to monitor.
But "Drive Settings" in 'System Properties/System Restore' the choices are
greyed out. ie; Turn off System Restore(disable by Group Policy) and Turn off
System restore on this drive in Drive Settings. I have checked in services in
administratyive tools. Botj System restore and RPC and started and on auto.
Maybe one could show me what I'm missing. I'm getting too old to remember
this stuff...Newbie Excel question
I need an Excel spreadsheet to track my running balance. I have it al
laid out in Excel and it looks like this.
CHX # DEBITS DEPOSITS RUNNING BALANCE
OPENING BALANCE 2,557.93 $2,557.93
Norms Stump Removal 8514 -$175.00 $2,382.93
Angela Paycheck 8535 -$191.49 $2,191.44
David Bayard Paycheck 8536 -$326.17 $1,865.27
David Bayard Paycheck 8541 -$365.00 $1,500.27
City of Oakland 8503 -$45.00 $1,455.27
Norms Stump Removal 8561 -$350.00 $1,105.27
Norms Stump Removal 8565 -$170.00 $935.27
David Bayard Paycheck 8569 -$329.43 $605.84
MCI ...Excel filter not working
I have a large spreedshett(800 lines)
I clikced on DATA>FILTER>AUTO FILTER
and the arrows shopwed up on the various col.
One of these Col is called DATE
I click in the DATE arrow and select BLANK to find all the entries that do
not have a date showing.
This works well until about line 701
The line numbers to the left all turn blue and all is well
BUT in the following lines that the col displays dates and the numbers on
the left have not changed color
I thought that once the filter was set to BLANK only the lines that are
blank under DATE would appears. This is not the case
Can any one h...RMA ( Credit) Missing Line Items
This is a multi-part message in MIME format.
Two RMA documents were received and then set as "Ready to Close". Both =
documents show, in GP, as "History" but missing the line items.
Checked the SQL tables and both RMA documents are in the "open" tables =
(SVC05000 and SVC05200) and the line items are in the tables and appear =
to be linked to the header. =20
How do we get the line items to appear on the RMA docu...