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" <email@example.com> wrote in message news:ED708...Tracking shared records
I need to create a report that shows which records are shared and with whom.
Can someone guide me in the right direction? I can't seem to find it anywhere
online. thank you
Sharing is recorded in the PrincipalObjectAccess table in the SQL database.
Advanced find does not allow you to access this so you will have to create a
report on the directly on the database.
Patrick Verbeeten (MCPD)
Extended Entity and Plug-in browser:
> I need to create a report that shows whi...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...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...VCR to DVD Part 2
Many thanks for previous answers.
Yes, finalizing the DVD worked
I found that DVD-R need finalizing but DVD+RW disks do not
But why was I able to play the unfinalized DVD-R on one machine and not on
What was special about the first PC?
Bernard Liengme wrote:
> Yes, finalizing the DVD worked
> I found that DVD-R need finalizing but DVD+RW disks do not
> But why was I able to play the unfinalized DVD-R on one machine and not on
> two others.
> What was special about the first PC?
Almost anything will play a finalised D...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <email@example.com> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...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?
> ------...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...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
...Does POS 2.0 support price-embedded barcodes?
Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
barcodes (also known as random weight barcodes)?
I have Digi scales that print out 12-digit barcodes with UPC and price info.
I would like to implement POS and not RMS because it is much less complex.
Thanks for any info.
POS 2.0 does not support price-embedded barcodes.
> Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
> barcodes (also known as random weight barcodes)?
> I have Digi scales that print out 12-digit barcodes with UPC and price info.
&...How to enable the tracking log?
I am just looking for how to enable the tracking log....I
do know how and where, but if I want to enable the
Tracking log, the server will show me some error message
or not responding. I thinks it has to communicate with
other server. but it will be the trouble due to we have
broken the VPN, also I can't delte the directory
duplicate. it still want to keekp it alive...
The question is:
No.1 How to enable the tracking log, I konw how but can't.
No.2 How to delete the directory duplicate connector
after break the connection with other exchange5 server.
could somebody tell me how a...IMAP address on exchange sever #2
how can I find the IMAP address of my exchange server?
I need help with the following:
I need to plot a 2-D column graph comparing the profit margin (y-axis)
for the 3 items (x-axis) for Malaysia and Singapore, using the data
Item Mfr's Agent's Retailer's Selling GST Profit Total
Cost Charge Markup Price Margin
Lipstick 9.85 15.76 12.81 38.42 1.54 27.03 105.40
Toner 11.90 19.04 15.47 46.41 1.86 32.65 127.33
Cleanser 15.90 25.44 20.67 62.01 2.48 43.63 170.13
Total 37.65 60.24 48.95 146.84 5.87 103.31 402.86
Item Mfr's Agent's Retailer's Selling GST...Report: Cell #1, Cell #2, Cell #3, Cell #4
I am stuck again and would love som help :(
I would like to repeat all words found inside ~25 cells, separated only
by ", ", ignoring empty cells.
A1: [Apple ]
A5: [Syrup ]
A6: [ ]
A7: [ ]
A8: [ ]
The result should be something like:
[Apple, Orange, Banana, Tomato, Syrup]
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?thre...Application icon #2
Have a strange problem. I recently used the tool ResOrg to renumber the
resource IDs in a project where there were hundreds of duplicates. This
fixed a list of bugs, which is why I did it. The other programmers found
three problems after this. One was trivial to fix, a second was actually a
problem in the code that renumbering the resouce IDs uncovered and was also
The third one is weird though. Renumbering the resources messed up the
application icon. I verified this by recompiling with the old resource.h
file and the icon is correct.
In the renumbere...Backing Up Outlook #2
I have Windows XP Professional installed. Is there a
simple and straight forward way to back up all my Outlook
folders and address books to CD?
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"mel weston" <email@example.com> wrote in message
> I have...direct deposit #2
I am in the process of setting up payroll. I am able to import(using
Employee info, deductions, benefits, taxes, etc.
I cannot seem to find anything about importing direct deposit information.
Any assistance will be appreciated.
As far as I know, there is no integration within integration manager that can
handle this. The last time I ran into this, I had to use some sql scripts to
get everything in to GP.
> I am in the process of setting up payroll. I am able to import(using
> integration mgr)
> Employee info, deductions, benef...How to run ajax implemented .Net 3.5 to an old version 2.0
I have developed a Web Application in .Net 2008 and implemented
<asp:UpdatePanel /> in it.
But now I am trying to build it in .Net Version 2.0.
But it gives an error -- "Error 1 Unknown server tag 'asp:UpdatePanel' ".
I have downloaded earlier version of AjaxControlToolKit, but it does not
What I have to do to build this code in version 2.0
Thanks and Regard
The UpdatePanel is not part of 2.0 or the Ajax Toolkit. This is an
additional "Ajax extension for 2.0" download...
Also as 3.5 is just 2.0 plus additional stuff, I wo...