open an excel sheet in works
Is there a way to download an excel sheet and open in works or works spreadsheet?
Not that I know of.
"mike" <email@example.com> wrote in message
> Is there a way to download an excel sheet and open in works or works
...Printing Visible Sheets in Sequence
I would like to print all of the visible sheets within one
workbook with sequential page numbers. How could this
macro be modified so that only visible sheets are loaded
into the array? Thanks for your help.
Dim ShtList() As String
Dim ShtCnt As Long
ReDim ShtList(1 To ActiveWorkbook.Sheets.Count)
For ShtCnt = LBound(ShtList) To UBound(ShtList)
ShtList(ShtCnt) = ActiveWorkbook.Sheets(ShtCnt).Name
Dim ws As Worksheet
Dim arr() As String
Dim N As Integer
N = 0
...Increasing # of rows in excel sheet
I usually import data from other programs such as SAP
into excel and face the problem of excel running out of
Rows.. is there a way that I can increase the total
number of rows in my worksheet or any other solution
possible to my problem.
no. 65536 rows is the maximum
> Hi all..
> I usually import data from other programs such as SAP
> into excel and face the problem of excel running out of
> Rows.. is there a way that I can increase the total
> number of rows in my worksheet or any other solution
> possibl...Embed Sheet
I am working on a sheet with approx 3000 entries, The first colum
stores the company name, second stores customer number and so on.
company can have many customer numbers which causes alot of compan
name repitition in the first column. Is it possible to embed this shee
into another one and use a combo box filled with all the company name
to access the specific areas of the embedded sheet?
Any help would be greatly appreciated.
Message posted from http://www.ExcelForum.com
I think this sounds do-able - first look at
Chip Pearson's page:
http://www.cpearson.c...How to copy block of cells and keep grouping?
I have about a 150 by 30 block of cells. About every 5 cells are grouped
together, making it significantly smaller. when you click the "-" to
have them contract.
I will take me days to go through and make all the groups again if I
want to make the same block on the same worksheet.
Is there a way to copy a block of cells and include the grouping?
dstock's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24225
View this thread: http://www.excelforum.com/showthre...How to stop: Outlook keeps sending emails from outbox
One of our PCs in network had virus before. It is cleaned via Mac Fee
antivirus software. The person has that computer confirm that her PC has no
virus now. However, her Outlook sometime keeps sending a certain email
multiple times. The other who receive that email then has the problem: some
how the email is auto-replied. The Mac Fee warns that the outlook sending
mail multiple times and it could be a virus.
At least, there are three people in the local network has the infected
emails from the first person.
The Antivirus software has not found anything after scanning. They also used
Micro T...Which files to save to save the whole OS design?
I am not sure which files I need to save to be able to rebuild the whole OS
design later or on another PC. I read that I don't need to save everything in
my OS design folder. But is the solution file and the *.pbxml enough?
Thank you for any help
Yes.Only .sln and .pbxml files are enough to rebuild your OSDesign folder in
If you have any subprojects created on it then you need to backup the whole
"Martin M" <MartinM@discussions.microsoft.com> wrote ...Keeping Foldres Expanded
Everytime I close outlook and re-open it again, the
expanded public folders have all collapsed.
Is there a setting to keep these public folders constantly
...copy data from one worksheet to identical sheet in different workbook
I want to essentially sync the data between 2 identical worksheets in
different workbooks. Essentially, I want to import and replace data in
the second sheet with data from the first, is there a simple way to do
this without deleting the worksheet and then copying the new sheet into
You can right-click on your source-sheetname tab,
the shortmenu will reflect Copy/MoveSheet....
Select it and make 2 other choices:
1) Check to Create Copy box at bottom
2) From dropdown box at top of screen
select an existing open workbook or select
"a...moving to end of sheet
I know that "ctrl-end" should take me to the end of a
worksheet. Sometimes, however, it takes me beyond the
last row where data is entered, sometimes many blank rows
beyond. I've tried deleting those blank rows, making sure
there is nothing hidden inthose rows, no conditional
formatting, etc., but that doesn't work. If I cut and
paste the rows with data into a new sheet, that works
(i.e., "ctrl-end" takes me to the last cell with data in
it). Is there a way to do this without the cut and paste
There are instructions here for resetti...Can you keep flagged items from being autoarchived?
I would like to be able to let my autoarchive run but for it not to take
flagged items to the archive. I keep having to pull them back into the
current mail file. Is there something I can set to accomplish this?
Hit Alt-Enter while you've got one of these items highlighted then set the
option to not AutoArchive the item
"dstuart101" <firstname.lastname@example.org> wrote in message
>I would like to be able to let my autoarchive run but for it not to take
> flagged items to the archive. I keep ha...Outlook 2002
Tasks from the calender continue to pop up even though
they have already been completed in Outlook - Any
suggestions on how to fix this?
Pop-up as in the reminders still appear? Try this:
Select Start | Run
Enter Outlook.exe /CleanReminders
(note the space between ".exe" and "/CleanReminders")
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Steve" <email@example.com> wrote in message
news:0...Require Tax Detail Totals to Match the Pre-Tax Amount in SOP and .
Please incorporate the Require Tax Detail Totals to Match the Pre-Tax Amount
functionality into POP and SOP. I created a CR/PR on this and dev informed
me this was a product suggestion. This is very important functionality for
European clients in terms of producing correct VAT returns.
...Excel spread sheet
Why random data is replaced with a number symbol. Date entered as 2/2/2010
but ######## shows up in the cell.
iCould be a number of reasons:
First try either widening the column or reducing the font size.
Come back if that doesn't work
> Why random data is replaced with a number symbol. Date entered as 2/2/2010
> but ######## shows up in the cell.
...Drivers for Dongle keep having to be reinstalled after reboot
Everytime the POS station is rebooted the dongle drivers get uninstalled.
The user gets the copyprotection error message and they have to reinstall the
Try logging on as Administrator to install the driver.
Stop fishing for e-mail
> Everytime the POS station is rebooted the dongle drivers get uninstalled.
> The user gets the copyprotection error message and they have to reinstall the
> Any ideas?
Tried that ... Didn't work.
"Terrible Tom" wrote:
> Try ...Receive PO based on amount.
Greetings GPLings.. :)
Is there any way to receive with invoice , a PO that contain service /non
inventoried items based on the amount?
Eg: PO amount $100000000 for ONE service item and i would want to receive
and invoice only $ 200.
The reason i used this huge amount as PO is that even if i used a decimal
value to receive the PO as a percentage,it will still not be accurate as GP
allows only 5 decimal places.
In a simple form, i want to receive based on the amount rather than qty.
The only way to do that is to enter the PO for a quantity of
100,000,000 at a unit...All outbound e-mails keep getting assigned to a campaign
I created a quick campaign and performed a successful mail-merge, then
sent the e-mail. A response came back and I promoted it to a campaign
Now when I send a normal email to a different user, CRM automatically
assigns that email to the campaign history! It's not targeted to a
user that was in the campaign. Even my personal email is getting
loaded into that campaign in CRM, in fact all my outbound email is
funneling into that campaign. Is this a bug? Can someone who has
encountered this issue please help?
You are not alone!
This happened to a user of...Mouse cursor freezes up semi-permanently with whole computer
Just got my first Vista computer and dont know where to turn for
assistance with this problem: Tried googling it and all I can find are
people whose mouse freezes for a few seconds but which starts working
again. Every few hours (or more often), my mouse cursor and whole
computer freezes. The only way out is to control-escape into a switch
user and then (as there are no alternative users) log in again. As
soon as it logs out, the mouse starts working again. So this doesnt
seem to be a hardware issue?
The only other symptom I have noticed is that occasionally at all
sorts of odd tim...Insert sheet, move to end, rename with cell data.
I've spent most of my day trying to ask VB to do this for me, but don't
know how to communicate it correctly.
I have column A in "List"(Sheet1) with 150 entries.
I want to create 150 sheets with Sheet numbers of 2-151.
However, I would like for the tabs to read what the appropiate cell in
was my column, I would like the first four tabs to read "List" (my
original sheet), "Fun", "Not Fun", and "Cool".
Then they would appear in Microsoft Visual Basic as Sheet1(List...calculating different percentages depending on amount
I'd appreciate help with a formula
I need a formula to calculate the following
4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on an
amount above $41,100.
ie $20,000 would be (20,000 x .045) $900.00
ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50
pgruening's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2601
View this thread: http://www.excelforum.com/showthread.php?threadid=47878
Here's one which may work. Just substitute...Something to help me keep track of formulas
Is there an Add-In or some third party software that can help me manage my
formulas. They are getting very long and I can not figure out what goes
where. I am looking for something free if possible. THanks.
Here is an example of my formula that's too long.
ABCone'!$A$11:$I$300,9,FALSE))*(VLOOKUP(A12,'%'...Excel 2k opens 2 sheets within same window
We have excel2k with sp3 on win2k pro with sp4.
my problem is when i open 2 excel sheet both appear within the same window.
if i have to switch between the 2 sheets i have to minimise 1 n maximise the
what i need is to open both the excel sheets in 2 separate excel windows.
how do i do this? please advice
Under the "show" section, make sure that the "Windows in Taskbar" option is
checked. This should solve your problem. It might be slightly different in
Excel 2000, but the same options.
Hope this helps
"sp...How do I link cells, sheet to sheet, to recognize row deletions?
In Office XP - Excel - I want to copy a column from one sheet to another
sheet in the same workbook. I want the copied links to recognize row
deletions and insertions when I change the source sheet. When I use the
Copy, Paste Special, Paste Links command, the linked sheet does not recognize
a row deletion in the source sheet. Instead, the linked sheet displays a #Ref
message in the cell related to the deleted row.
One way to try ..
Assume the source col to be linked is col A in Sheet1, A1 down
Put in any starting cell, say A1:
=OFFSET(INDIRECT("Sheet1!A1&qu...Password prompt keeps popping up.
My network connection password request keeps comming up every minute. The
'test settings' feature says that incomming mail is not happening because of
an incorrect password. New incomming mail is being turned away. What is
> My network connection password request keeps comming up every minute. The
> 'test settings' feature says that incomming mail is not happening because of
> an incorrect password. New incomming mail is being turned away. What is
A "network password" is completely different than...Excel Data Protection Best Practice: AKA: Real Sheet Protection
Any advice for best practices for protecting data/methods/macros within
Excel? Clearly, password protecting a sheet isn't the best security (free
utilities to crack it).
- I need users to be able to access the workbook, but by no means, gain
access to data within the certain sheets
- I can hide the data by utilizing similar colored text and hiding the
- Once the password is created, it appears there are tons of free utilities
that remove these passwords- Bummer.
- Any advice to help prevent the utilities from doing this?...