How to sort multiple sheets (which have same format) at one time?
I have a workbook with multiple sheets which have the same format. I need to
sort all in the same manner. How can this be done.
I noticed that the sort function is not available when selecting/grouping
I'm going to take you at your word and make a few assumptions. Taking you at
your word: ALL sheets in the workbook need to be sorted. Assumptions: only 1
column is used to determine the sort order, and the sort is to be in
The following code will do that, and allows you to define which columns are
included in the sort, and which column ...why wont an excel doc open with new msn office
i have just got a new comp with the new microsoft woeks on it, word doc if
differant, and a few other things but an excel doc was sent to me an it will
not open it ????????
MS Works is a 'light' version of Office, containing a 'light' version of
Excel and a 'light' version of Word. You cannot open Excel or Word files
with Works. You'll have to get the files saved as .csv or .txt or a Works
file to be able to open them with Works.
"peterk4" <email@example.com> wrote in message
news:53597904-F529-4E67-BC56-D957C375779...excel pivot table with sql query and visual basic macros
I have a pivot table that runs off a sql query, it has macros and parameters
built into the report. It worked until the client updated their server and
When debugging this, on the module under the closedb it stops here:
'IF CONNECTION IS OPEN IT NEEDS TO BE CLOSED SO AN ERROR IS NOT THROWN
If rsData.State = 1 Then
Set rsData = Nothing
Set cnData = Nothing
Set Cmd = Nothing
...With Microsoft FAX Nearly One Minute Delay between Using Print
With Windows Messaging and Microsoft Fax under Win 98 SE, when I
printed a document to Microsoft Fax, the fax wizard would start a few
seconds after I said print.
I installed Outlook 2000. With it, there seems to be a consistent
nearly one minute delay between when I say print and the fax wizard
If Outlook is running, there is no delay.
The osa9.exe program doesn't make any difference.
Needless to say, this is an annoyance, having to go through two steps,
start Outlook and then print, rather than simply printing.
Does anyone know of a way to make Outlook 2000 work like Messag...Excel 2002 Create Workbook (merge/reformat)?
I have 12 seperate spreadsheets I want to combine into 1 workbook (12 tabs).
Any other alternative ways to do this other than copy and paste? Need to
reformat "most" of the worksheets, I assume this can be done if all 12 tabs
are selected. I may have to do this several times otherwise I would just
copy and paste. Each spreadsheet has an average of 3k-4k transactions.
You can open the workbook, ctrl-click on the worksheet tab and drag that
worksheet into another workbook.
(Then close that "sending" workbook and open the next...)
> I have 1...Excel 97-remove link but keep data
I have a pre-existing excel 97 s/s which has links to other s/s's. I would
like to keep the data only (like paste-special, values) and remove the linked
reference from showing in the current s/s. Any ideas how to do this instead
of me changing each linked reference?
Thanks in advance!
search for .xls or [ or ] to see if you can find the formulas that contain links
to other workbooks.
> Hi guys,
> I have a pre-existing excel 97 s/s which has links to other s/s's. I would
> like to keep the data only (like paste-special, values) and rem...Excel file takes a long time to save
I have a 1,000 x 15 straight worksheet with no formulas - about 100K.
I went to auto-format a pattern, but didn't select the area and
if formatted the entire spreadsheet. It's since gone from 5 seconds
to 60 seconds per save and I can't reverse this, even by changing
the auto-format setting to "none."
I'm backed-up, but the current version is about three hours ahead and it
will take longer to retrace the work by hand.
Try resetting the last used cell.
Debra Dalgleish has some techniques at:
http://www.contextures.com/xlfaqApp.html#Un...CListCtrl and paging???
I know CListCtrl can display items per page, for instance if table contains
1 millions records or 10. for display items from that table we should divide
all items per pages and display that pages in CListCtrl.
Question: how to do this - I mean API. If somebody have source - send me pl.
I'm not sure what you are asking, but a virtual list control sounds like a
"Nothing" <Vinnitsky@msn.com> wrote in message
> hi anybody
> I know CListCtrl can display items per page, for instance if tabl...extra blan page
I have a report and set footer force new page after section.
The report always has one extra blank page at the end, since force new
page after section.
Are there any way to eliminate the extra blank page at the end of
report when the report force new page after footer section set?
Your information is great appreciated,
I have a report and set footer force new page after section.
>The report always has one extra blank page at the end, since force new
>page after section.
>Are there any way to eliminate the extra blank page at the end of
&g...Using Excel 2000 as Data source for Word 2000 document
Problem using Mail Merge using Word 2000 & Excel 2000.
After numerous problems - Word failed to connect to Data Souce file then it
would & then it wouldn't and so on - reasons which are unknown!
The 106 records in 19 fields from the Excel Data Source are only
transferring the information for the first 104 records.
I am looking to add further records but obviously need to overcome this
Obvious, perhaps, but are you certain that the records are in consecutive
rows & no vacant columns separating the fields of data? Does the data range
contain any Merge...Excel design questions
I'm a new to excel. I'm assigned task to perform creating charts
based on the following data. I explored little bit from web about the
capabilities of excel, but few areas I'm not still quite sure about how
to get it working.
- Is it possible to have advanced filter to automatically refresh if
the data is changed on which the filter is acting on?? Do I need to
write maro for this??
- If i have a column with data (different types of tree names, ex:
Apple, Apple, Maple, Grape,Grape..etc - name is repeatable). Can I
uniquely get the name of all the different tree names automati...Excel 2000 #9
Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
Excel in any version uses the Short Date format from Windows Regional settings
You can make some minor changes in Regional settings but not too much.
How about a macro to add the date in any format you choose?
.PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy")
Gord Dibben MS Excel MVP
On Tue, 5 Feb 2008...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...Visio2k7 has two PDF export methods
I have a floorplan diagram that is 20"x20". On the diagram, there is
metadata for the shapes of the offices that tells you the person's
name, phone #, etc.
When I use the "Publish as PDF or XPS", the Image is exported
properly, as shown in the link below:
But none of the metadata comes across - and there's no option to
include it either that I can find.
However, if you use the "Convert to Adobe PDF" option, you get the
The i...Can I export Distribution Lists?
A different department has asked us for a copy of all our distribution
lists, members of those lists, their smtp e-mail addresses, x500 addresses,
as well as group owners and who has rights to send to thos lists. How do I
get that? We have about 100 distribution lists each with about 100 users.
We are running Windows 2000 and Exchange 2000.
- Scripting this would produce much more readable output. I was able to
modify a script I wrote a while back for general use. Posted to blog:
It doesn't hav...How do I create a 46 page member directory?
I was wondering if publisher can create a membership directory that would be
46 pages in length? The front of the handbook would be the names/adresses and
so forth and the back part would be images of each businesses business card.
Is publisher the right software for this? I was volunteered for this job, so
any help would be most helpful!
I'd use Publisher if I was doing that job.
MVP Microsoft [Publisher]
"Bryan" <Bryan @discussions.microsoft.com> wrote in message
>I wa...Multi-User Excel File on a Network Drive
How can I make an Excel file accessible to multiple users concurrently?
With all able to make and save changes to the same file.
> How can I make an Excel file accessible to multiple
> users concurrently? With all able to make and save
> changes to the same file.
Tools / Share Workbook
...Inserting Rows in Excel
I have a spreadsheet with a unique identifier for each
customer, Customer Information File (CIF). Whenever this
number changes, I want to automatically insert a blank
row. This will merely making the the spreadsheet more
pleasing to the eye to read. Keep in mind, there may not
be a break in CIF for 1 to 15 lines, but whenever this
CIF number changes, I want a new blank row.
Any help would be greatly appreciated!!
Macro solution OK?
Dim i As Long
.Calculation = xlManual
.ScreenUpdating = False
...Page No display
How to insert page no in a particular cells.
I had tried with Header option in Print Preview menu, but after
applying the same , Page no is not exactly comes in particular
cells,either it may displayed above or below the cells.
NITESH G's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17590
View this thread: http://www.excelforum.com/showthread.php?threadid=497514
...charting a single bar graph on one line showing continuous info
I must do a time graph showing total workhours with tick marks showing begin
and end of tours on a dialy basis. I cannot get the custom or standard chart
graph functions to do this without putting in all of the data. I just want
the begin tour and end tour of each person. can you help. thx
...pivot table page field hidden items
Is there a vba code that can determine the "pivot table page field
I tried the "visible" property for the page field items. It returned
"True" only for the "CurrentPage" item and "False" for all the others.
You could set each item as the current page. Those that are hidden will
create an error, instead of becoming visible. For example:
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
Dim piCurr As String
Set pt = ActiveSheet.PivotTables(1)
Set pf = pt.PivotFiel...Use Excel to update Outlook address book
Is there a way to update outlook address book using excel? Is there a
macro available for it?
Thank you for your answers
...Compress an Excel File
I have an excel file that is 36 meg. Do you know how to
compress the file? When I zip the file it drops to 3meg
so I know it can be compressed.
I beleive the file has become large due to the constent
changes I need to make to the file.
Maybe this will help?
You can use Rob Bovey's Code cleaner to clean up your code
Regards Ron de Bruin
"Mandy" <firstname.lastname@example.org> wrote in message news:42c401c47fa1$ddc405d0$a401280a@...Tracking an email when sent directly from Excel
I often use the feature File>Send To>Mail Reciepient (as attachment)
when I'm working in an Excel Workbook. However I can never find any
record of this in Outlook, or anywhere else. Is there a way so this
gets recorded in Outlook, or can you tell me where I can find some
record of the email and its contents.
On May 18, 7:23=A0pm, Rob <robfl...@sbcglobal.net> wrote:
> I often use the feature File>Send To>Mail Reciepient (as attachment)
> when I'm working in an Excel Workbook. =A0However I can never find any
> record of this in Outloo...Diable excel macro for DATES
everytime i copy and paste from a website in this format XX/YY
excel sees it as a DATE. how can i disable this feature..I just want t
paste it as its raw form of XX/YY. When i cut and paste it in my exce
and try to change the format by using TExt. it comes up with rubbis
Message posted from http://www.ExcelForum.com
try formatting, as text, before you import
"evo >" <<email@example.com> wrote in message
> everytime i copy ...