Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...Accessing Windows Office Templates
There are some very nice templates at the Windows Office Template
Gallery. I would like to download (mostly Word, but a few Excel) some
of these templates, but the format comes out with a ".cab" extension
that Office v.X doesn't understand.
Is there any way to get these templates? Unfortunately, they make the
Mac template archive look very weak.
Microsoft has a Mac template download page:
There's a link to the on-line gallery on that page. It looks like a newly
re-designed gallery to m...Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
A better solution is offered at
http://support.microsoft.com/kb/918165 "Problems in Windows
Explorer or the Windows shell after you install security update
Patricia Shannon wrote:
> If you have installed a Windows update and started having problems opening,
> closing, copying files, see:
> http://ww...Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...Outlook 2000 not opening.
I am having a major problem with outlook. Can anyone tell
why Outlook will not open when selecting it. When I check
in the processes there is an instance of Outlook.exe there
but it is not doing anything. When a different user logs
onto the machine Outlook will open fine with no problems.
I have deleted the users profile and recreated it but to
no use. I have tried comparing the local registry keys of
the two users and they seem to be the same.
Can anyone please help me as I have ran out of things to
Thanks in advance.
Does Outlook start in /safe mode? (I'm assumi...Using scanner in Word97
I want to scan a picture into word97 using my HP 4370 ScanJet. Could not
find option of "From Scanner" under "Insert" --> "Picture". Apparently I
must need some sort of Word97 Add-On. What and where is the add-on? Is it
on the Office97 CD? Same applys to Excel97.
Also, does microsoft sponsor a Word97 / Office97 discussion group? If so,
would appreciate a link.
"PSRumbagh" <PSRumbagh@discussions.microsoft.com> said this in news item
> I want to scan a picture ...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...About Exit and close window.
I have a dialogue base application. There's an Exit button in it. Eachtime
when exit the program by clicking Exit button, fun() and OnOK() executed,
but if the window is close by clicking (x) on the upper-right coner, fun()
will not be executed. How to make this function--fun()--executed when click
(x) button on the upper-right coner?
Rather than calling your fun() from the Exit event handler, call it from the
dialog closing event handler, so that no matter how it is shut down, that
method is called, and so is fun().
hope that helps.
"sxy7711" <sxy771...Office installation and Windows 7
I got a new computer today with Windows7. It is a 64bit system where I had 32
before. I tried to install my Office Professional 2007 and it would not
install. I got a message that Microsoft would check the problem and get back
to me, then another message that the program was shutting down. I am in
school and really need my Office. Is there a way around this so that I can
get it installed?
Doesnt make any difference, 64 / 32 bit.
Does your new PC have a Trial Version of Office & Activation Assistant that
you failed to uninstall first, then rebooted?
"Linda...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...is it posible to keep the quick launch icons in a specific layout?
I have moved the task bar tot he right side of the screen.
I have a number of applications which I have 'loaded' onto the quick
launch section of the task bar. Now, aside from the fact that
Microsoft seems to have different icons for it's products in Vista and
XP (and the confusion that is causing), is the small minor detail that
the vista task bar seems to reorganize at random. I've set up two
columns of icons, with tasks "lumped" together in rows according to my
own preferences. (mail washer next to the email program, the MP3 tag
program next to ...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
news:DA9FFF99-FC28-...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Opening Multiple Web Links in a Column
I am very new to using web links in excel. A task I do very often is
open a list of different websites that are in various columns in an
excel spreadsheet. I am quite sure I am doing it the slowest way
possible, so I need some help please. Basically I have been clicking
on one link at a time. When I do this, the first website opens and
excel automatically minimizes, then I have to go re maximize excel and
then click the next web link and the same thing happens, etc... very
time consuming. I am wondering if there is a way, either through Excel
or whatever means necessary, to open all...Is Outlook 2000 compatiple with Windows XP Home?
It seems to be having problems if it is... something like
Outlook has experience a problem and must close. I rand
the compatibility wizard, but it didn't help. Can you?
I have Outlook 2000 installed on my XP Home machine and
it works fine.
>It seems to be having problems if it is... something
>Outlook has experience a problem and must close. I rand
>the compatibility wizard, but it didn't help. Can you?
Rod <email@example.com> wrote:
> It seems to be having problems if it is... something...Install ActiveX on Windows XP / IE8
I created a non-admin installation package to take advantage of the new IE8
features to deploy my ActiveX control.
It works perfectly on Windows Vista+ but not on Windows XP (the yellow bar
is never displayed).
Here is the content of my INF file:
If I remove the Deployment section it works...how can I do a lookup into another sheet?
how can I do a lookup into another sheet?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Try something like
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"melawaisi" <firstname.lastname@example.org> wrote in message
> how can I do a lookup into another sheet?
> ------...Using Publisher 200 with Publisher 2003
How do I covert PUB2000 documents to Pub2003 documents and vice versa?
Pub 2003 can open anything, no conversion necessary. Going backward is a bit
trickier. File - Save As and chance the file type to a Pub 2000 file.
Possible problems can arise if you've used a feature that was not available
in the 2000 version and your file size will grew immensely.
MVP Microsoft [Publisher]
"nasuco" <email@example.com> wrote in message
> How do I covert PUB2000 documents to Pub2003 do...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Cannot Drag Open Desktop Screen
I have a friend running XP MCE (2005) SP3 and he cannot drag an open
screen on his desktop by Left clicking and holding cursor on the top of
Any suggestions as to how to remedy this problem of not being able to drag
a screen will be appreciated
On Sun, 14 Mar 2010 16:48:43 -0400, "ColTom2"
> I have a friend running XP MCE (2005) SP3 and he cannot drag an open
>screen on his desktop by Left clicking and holding cursor on the top of