View Full Version : Microsoft Excel Misc
- Inserting a destroy function which destroy a model after few runs
- More macro
- A couple Of Questions RE:"comment" Feature
- CSV File and Excel Format
- Excel Crash when save one file
- calculations within a pivot table
- Replace
- Is there a way to remove a menue option (other than macro code)?
- Pivot Table Help Needed!
- do I need to use a roundup func.??
- Re: auto save
- Excel range ! versus :
- Formula too long
- Frank Kabel...need your help
- Any short key finding special cell?
- When 1 inserted in cell 0.01 displayed
- Excel data labels from other data
- Prevent users from saving a workbook
- How do I compact my spreadsheet
- Spreadsheet opening as an email to send
- Cannot find file. Check if libraries not missing
- subtotal w/o grand total
- First in First out
- Changing Text
- Excel 2003 colours only show when workbook is printed or previewed
- Automation/macro
- XLQUERY.xla
- General Protection Fault in Excel???
- How do I calculate my GPA in Excel? please help me!
- Print specific pages
- Rotate Button Text
- Getting chart series values from object values
- Problems with multiple sheets
- Protect worksheet names
- macros on a form
- Excel 2003
- Calculating an average
- Need program to ask me to save changes when closing
- creating text file without delimiters
- 3D plot animation?
- Protect the Format Only of a Sheet
- Histogram - Dynamic link to source data
- How to convert number format to Date
- Import External Data
- Virus Warning
- Insert / Delete a line keeping the order
- Help Re-formatting Cells (not as easy as it sounds)
- conditional formatting
- VBA compile error label not defined
- hour format
- Importing from Filemaker Pro 5.0
- multipying percentages
- Removing deleted text
- Error in mail merge after changing zip code field codes
- Re: RE: Excel Limitations & Possible Add-Ins
- linking to another workbook
- IF formulas
- Re: Identifying cells that add up to a particular sum
- feeding a word table from an excel table
- linking to other workbooks
- Find/Replace problem that I *thought* was simple?
- Re: Identifying cells that add up to a particular sum
- NG problems
- Excel 03 bugs
- cant open excel & word docs that have ben emailed etc
- my spreadsheet has cancer
- Enter formula, yellow help box, how do i turn it off?
- Entering More than 15 numbers
- office assistant
- How to turn off clipboard in Excel 2003
- Return the Name Box/Current Cell Address
- Breaking Links in Excel 2000
- Re: auto save
- Setting the Default font for Headers and footers in Excel 2002
- Adding within a cell
- can't change default file location
- Array Functions
- Block entry into a cell if another cell has a value
- missing macro toolbar
- Printing Ink Annotations
- Formatting still not kept....
- Filename
- Chart Labels
- Using cell text as a Sheetname in a formula
- history of excel
- "Disk Full" message
- wrong "default file location" after installing Office-addin
- MSN/Excel related problem
- Converting date from cyymmdd to dd/mm/yy and sorting pivot table
- Increase number of IF statement?
- auto updating pictures in charts with lookup function
- Formula help
- Excel file locked
- How to Adjust the Screen?
- save as,
- Xxcel formula re Multi-Cell lookup - DIFFICULT
- ODBC Driver For Paradox 7.0
- How do I lookup a code and then sum all cells in a range that correspond to the code?
- Cost-effective copying
- HOW: set of 3 equations using Chinese theorem
- Give them a Tip
- Find and Replace
- Replace
- How to make charts "exactly" alike?
- Where is the spreadsheet
- Text not displayed in cells.
- How do I prevent cell resizing in pivot table.
- When saving add automatically contents of a specified cell in document properties
- how to restore links automatically after server migration?
- Highlighting dates.
- Excel table is not correctly pasted into PPT and LN
- Re: Query/Pivot Table
- Sorting dates before 1900
- Excel: showing/printing formulas
- format of complex numbers
- EXCEL:printing row headings at the top of every page.
- Create Autoformat?
- Can not Read Excel files
- Populating Cells from a delimited string
- Worksheet won't leave outbox
- Constraints and Conditions for Capacity Reporting
- random sample
- Condintional Formatting
- Import Wizard
- Tax Invoice automated Tax number
- conditional formattingbased on dates
- Vlookup
- Opening to a default tab?
- 256-byte limit for space delimited text (*.prn) files
- Creating A Total Based On Multiple Conditions
- Vertical Scroll Includes Empty Cells
- text in cell looks different when printed
- Force Entry into a cell
- un/protecting multiple worksheets?
- Import-FixedWidth-Template?
- recalculating advanced filter?
- SUMIF
- text alignment
- Grouping/Sorting Cells
- Linking to Simply Accounting Pro 2004
- Booleans in Array formulas
- Huge Excel file
- Excel
- FORMULA
- changing style of legend
- Merge data of cells which have a similar "another cell value" like a primary key
- Formula for mm/dd/yyyy extract into separate columns?
- 'Document not saved'
- Hide Column if Grand Total is 0
- PDFmaker makes zero bytes PDFs
- FORMULA
- Offset help
- Excel
- determining identical ranges
- Calculate Intrest Rate
- Validated List Cell enters data into other cell
- Odd thing happened
- Subtotal and Auto Filter
- Show Pages in a pivot Table
- Random text replacement
- Mail merge w/xl file
- File not found message
- If criteria not met use msgbox
- auto fill cells with "formulas" from within the same worksheet
- keep cell borders when autofiltering
- Using Self Certify Digital ID with Shared Files
- Pivot Tables
- Not allowing duplicates to be entered in a column
- adding text to a sumproduct formula
- Excel formula problem for personal budget
- Not allowing duplicates to be entered in a column
- how do i ???
- IRR Calculations
- External Links
- External Data Query
- Read Only dialogue box not always displaying...
- Font Color
- Using an existing instance of Excel
- Insert Symbol in Excel Graph ???
- "Style 'Currency' Not Found"
- How do I lock the work sheet and then unlock specific cells?
- Going back to the cell you originated
- How to make back up file whenever I save excel file?
- Search and Update - Using a Ref. to locate and update info.
- How to email just one worksheet in a workbook?
- Multi-Function Argument... too many pieces
- hidden vb object is not hidden when excel workbook is first opened
- Need macro to copy a hidden row
- lookup question
- Getting info from an IF statement
- hydrology water-year date conversion excel
- Chart Objects Behaving Badly
- Vlookup query that checks 2 conditions
- keeping spreadsheet on server
- Formular required for month and YTD
- VLOOKUP- Multiple sheets
- Search Row Multiple Values
- disc
- Data Analysis Sampling Tool
- Using Between and countif
- Excel VBA Reffering to Active Cell
- Calculated Item in Pivot Table
- Damaging Changes made to macro
- Saving In Excel
- Link to Data Form.
- Linking
- How to insert a crlf?
- Forgotten Password on Excel Workbook
- Excel error codes translations
- Daily file save as webpage
- Excel sort lists with missing values
- Can'f find file GWXL97.xla
- Terms
- Date codes
- Pay in euros, dollers(US)..Pounds.
- Determining dates.
- Contract salary sheets
- Formula Problem XL2000 XP
- disapearing formula XL2000 windows XP
- BONUS Calculator
- Array
- Array
- Keeping Leading 0's in Hyperlink Displayed Text
- Lists
- Problem with saving
- Paste Special
- Excel XP web query - Unable to open URL... data not available
- mapping cells within same excel sheet
- Forms Tool Bar Incorrect objects
- Validating D.O.B
- validating
- Excel is saving on opening
- Quick Question
- data validation question
- Selling excel projects???
- How to enter value in calculated field?
- Excel - chechking corresponding data
- help Unable to record Macro !!!!!!!
- Any alternative to Excelfix ?
- How to Do Automatically Calculate a R/Y/G Heat Map?
- Hide 70 columns and print?
- Y-axis scale
- how to reference different workbooks/sheets in formula?
- problem with subtotal
- Help Please
- Print Set-up is using only 10% of Page
- Formula Help
- Pinning a row
- Cut/paste dates from web
- Rescale
- concatenat new line
- Email from excel
- Excel object in Word
- pivot table refresh
- Format all cells containing formulas
- xls file sizes / memory errors
- Copy down macro
- Imported Formats
- Save not completed!!!!
- basic addition of formulae
- Save excel file as text file with ; as separator
- Text Wrapping
- Error Message
- Format a range of cells if another cell is not null
- Any Visual Baasic Users Having Mouse Scrolling Problems?
- Help with macro
- converting degrees into degrees, minutes and seconds
- ISBLANK Global setting?
- Update a vaule of a cell after using it for a calculation
- Duplicate entries
- Ratio Help
- Cannot view data - columns too wide
- FORMATTING - Annoying Problem
- unwnated repeated characters
- Hyperlinks
- Follow-up Question?
- Macro for Printing
- Runtime error
- Help Please
- Price look-up
- External Data Ranges
- Merging Excel contact list with Outlook email
- Send to Mail Recipient - Lotus Notes
- Linking Multiple Tabs
- Re: Q about skipping blank rows
- Re: Auto-Filters on Protected Worksheets
- Excel2003 Has No Column Indicators on Slider
- complicated formula
- Is it at all possible to share .xls files and edit them w/o Excel Installed?
- Excel - Keyboard Shortcuts for drop down lists
- Is it possible to import an adobe acrobat file (pdf file) into excel?
- Linking to Master Spreadsheet
- Hyperlinks (automatic)
- Is it possible...
- vba function
- vba function
- Formula or VBA help
- View calculation and result simultaneously
- Re: Sorting w/combo boxes
- looking for a Paul Robinson?
- help with custom timer
- zero values
- Pivot Table Axis format
- Automatically update filtered list across worksheets
- Protecting a Worksheet
- Pivot table Blanks
- Removing Text but Not Numbers in a Column
- If Formula question
- file name
- Fixed Formating
- How do I link for updates?
- Dual Processors and Excel Performance
- excel vba - upon match entry, load macro?
- Linking tab names
- How to Tab over to a specific cell... not the adjacent one?
- missing filenames in Excel 2000
- subtotal problems
- Excel alternatives for viewing large files
- Auto Filters
- Multi-sheet Workbook
- Help!!! Want 2 print blank cells.......
- Macro & Protect Commands
- visible cells
- Help! Excel 2000 Template Data Tracking
- pay advice slip
- Replace text with page break
- Importing data to Quickbooks Pro 2004
- Need a FORMULA to round off
- Pivot Tables: New dimension members show up checked in dropdown
- export to text file
- automate 2500 cut/paste/format from internet to EXCEL worksheet
- problem selecting rows (or columns)
- Excel - Scrolling Scrolling Scrolling (Problem)
- to Frank Kabel Please
- Excel- Budget plan
- Linking to Access
- Summing every nth cell
- Import EXCEL 2003 file to EXCEL 2002 software???
- Is this possible?
- If stmnt
- Importing large text file-limitations?
- If formula
- Printing Comments
- Re: Pivot Tables - Permanently Wrapping Text
- FoxPro Files Too Large for Excel?
- Worksheet.
- vba or formula help?
- Different dialog box when copying and then paste special
- Issue Printing Double-sided
- Title bar missing?
- Re: Converting word to excel
- Overdraft interest model
- Excel 2002 Filters stop working
- tab consolidation problem
- Indirect not the correct solution???
- sum total base on 2 criterias
- How to activate an open worksheet?
- Re: ANOVA with missing values
- Linked Cell Zero Value
- help, problem.
- Drag and drop without changing the format of the cell left behind
- Calculate how many times a day of the month will occur
- Vlookup - 3rd post, help please!
- Corrupt document
- Working days between dates
- COLLECT DATA ON ONE SHEET
- How to set "Manual Calculation" as defauld options
- Large file
- Formula error?
- SumProduct
- ATTN: Need to import data from access database, hosted on web.
- Pulling records
- freeze panes problem
- How can I turn off rounding for numbers???
- Split Data
- Formula please
- Two or more same values
- Same values output
- Problems copying and pasting a chart
- Save as... on intranet
- Edit/Clear/All command overrides worksheet protection
- Displaying a VBA result in a different worksheet
- Excel Forms
- Importing large files
- Execl 2003 TAKING OUT OF SHARED
- Multiples entry macro
- Worksheet to template
- Converting Text to Number in 2000
- percent calculation
- Editing Links
- .xls comments & VBA ?
- #VALUE! Error
- keeping parts of a formula same
- adding more than 30 agruments to a formula
- Simple Cut and Paste Problem
- linking to external files
- building an external link based on a cell value
- Horizontal sorting???
- Change cell color on update
- How can I write a formula for: cell=+1*number of selections
- enter the same data but with different raw and column at one time in a group worksheets
- #DIV/0!
- File takes long time to open
- document not saving as template
- Excel
- What FONT does Excel Viewer use?
- Fornula does not calculate
- Excel 2000 How to remove worksheet protection without password
- Can't Kill file?
- Formatting Cells
- Date Range
- Placement of Columns in Database Query
- Interpolate data from a graph
- Formatting
- Formating Data pasted from internet
- Template Help
- Opening Spreadsheets in New Windows
- Dropbox on each cell of column
- deleting part of a cell
- Why do I print blank pages?
- need to hide formula ...
- Matching/Balancing Totals
- Inserting a transparent image
- *.xls file won't open even with Excel2002
- SUM- multiple conditions with text
- Help Please?
- Data Entry Form
- autofiltering over a range
- Create help file for Excel Workbook
- Linking formats
- Split screen sort of?
- Web Query / Link Copy
- EXCEL exception after upgrade from Office 2K SR1 to Office 2K SR3
- File already open problem
- Re: Gather values from multiple sheets
- Re: Gather values from multiple sheets
- Seperating text in a cell
- Pivot Items
- Spliting information in a cell
- Chart data combined with different types of data
- Hidden columns - get them back
- Help with D functions
- Sumif?
- Col. not printing in Windows XP
- Change from Upper to Lower Case
- Files tool long to open
- Re: Scroll Bar Stops Working
- Chart data combined with different types of data
- SUM a range based on month
- autoformat of (C)
- header positioning
- If Then?
- MS Query
- Radians and Degrees
- VLOOKUP
- converting numbers to text
- Any Help Would Be Wonderful!
- Random sample with proportions
- Re: Macros
- aggravated
- questions
- Hyperlink to a Word Template
- How can we get the subtraction of values in first 2 columns in the 3rd column
- Older version Excel compatible with XP
- Downloaded file using Outlook
- Pls help me !
- Last Cell
- Sort First and last name in single cell
- Confusing error message when opening and closing excel
- search value based on 2 criteria
- Formular
- headers and footers
- merged cells and filter
- Open another workbook with a button click
- Inserting a tick box?
- Pasting Word pages into Excel
- hide and expand rows with a +/- button
- Page breaks
- Excel Scrolling Problems
- How to add "Page number and Pages number" in cell ?
- Problems with Inserting Rows
- How to pass variable to a Sub
- selectively choosing data from column
- Auto-open file call from Excel VBA
- Few questions about VB
- MailMerge
- Scaling the x-axis
- If Function formula
- Printing Multiple worksheets to a single pdf
- shading rows with condtl fromat.
- Adding a prefix
- Re: RE: Excel 4.0 Help
- Opening Password protected Files from Macro
- Join two formulas
- Can Vba Help With Auto-checking My Spreadsheet?
- Built-in Number Format "#,##0_);(#,##0)"
- Cell Comments
- Possible conditional formatting?
- comment box quirks
- Some menu functions disabled
- Re: Help w/formula's possible scenarios
- Formula Help
- excel workbook takes minutes to close
- Cell Linking
- open a excel XP in 2000
- excel 2000 - Copy and pasting
- Excel
- conditional sum returns not expected
- Excel
- Create several sheets
- Text "12:00 AM" to Time Format
- Re: Converting from excel worksheet to CVS
- help with a formula
- selecting every second row
- Importing data to spreadsheet with formulars
- Re: Drop Down List
- Excel Document Headers and Footers in 'Send To'
- Drop Down List
- Deleting Hidden rows
- text file
- If Then?
- row shrinkage
- Msgbox
- Text File
- excel vba - protect sheet with conditions
- Report manager question
- Re: calculate ranking
- I'm stumped about a formula
- Losing leading zeros!!!
- Do we have a software which can export text to excel perfectly?
- Extract date from string of text
- Re: paste link (formulas) vs. values
- hide row 5 if a zero in cell D5
- Summarizing Worksheets
- columns
- Numerous fsa*.tmp files being generated
- How to increase max. Row count in an Excel sheet?
- Error File / Renaming
- automatically numbering worksheets
- ranges in excel???
- group rows
- Bold a cell based upon data in another cell
- Re: Conditional formating with dates
- cell conditional format with dates/colors
- VLOOKUP returns #N/A but want a blank instead
- date copy error
- excel template growing??
- How to redirct F1 to bring my Help
- Re: Macros
- date format not working correctly
- cannot open file from disc
- Convert .RPT to XLS
- Excel formula calculating between #'s
- Open a new instance
- help with previous sheet reference formula
- column headers
- lockups & unexpected program close
- Excel linked vs non-linked column data
- Counting Text Cells
- Printing value only cells
- Autofill by increment
- RE: Date calculations
- Help with IF statement formatting!
- Re: Date calculations
- Re: Date question
- Re: How do I select all non-blank fields in a worksheet via the keyboard
- Re: Row count
- RE: Date question
- NPV Calculations - Inaccurate on XL?
- Re: Derive Name of Sheet from Tab?
- Removing shadowed Text boxes
- Pulling data from remote pivot table
- Re: Changing the default value for an empty cell
- Subtotaling with formulas?
- Re: Odd =if statement
- Conversion of .wks files to Excel
- Re: Odd =if statement
- Re: Changing the default value to an empty cell
- Formula to Include Rounding a Number
- Comparing columns in a worksheet
- If, then trouble
- Excel 97 - Maximum Number of Records
- Changing from sheet to sheet
- Diagonal Cells
- Re: gradient fill
- Summing & Rounding
- excel sharing multiple users one file
- Re: gradient fill
- Re: Odd =if statement
- Help Gurus! Pivot Table Text as Data
- protecting a workbook from deletion
- Adding worksheets to tabs
- Excel closes immediately on startup
- -- in formula
- Excel 2002 Changes Screen Resolution
- Re: Background and file size
- Re: save an .xls to .prn
- Re: group by date in pivot table 2002
- Cell to show last day of month
- Shared workbooks
- Add In Program Only Problem On Lap Top
- Macro Help
- excel formula
- shortest distances
- Search/Filter to find values in another range based on two cell values
- Problem with an IF formula
- leadin zeros
- side by side spreadsheets
- calculating flexi time
- Problem with hide/unhide macro
- Pick from list
- help on comparing and hiding
- Replacing #N/A
- Unable to open Excel document
- double file in excel
- lookup ??
- excel pages in ie
- Names in column are mixed up
- Help with Formula Scenarios from yesterday
- Internally assigned List or Tablename of Auto-Filter?
- 'Pulling through' part of a formula to use in another sheet
- Heap Size
- vlookup or if/then with data validation and multiple spreadsheets
- Creating a worksheet with stats created from selected data...
- Re: Making "found" cells more visible
- Large Pivot Refresh problem Excel 2003
- Re: Making "found" cells more visible
- changes to the same worksheet within multiple files
- Sorting with Conditions-This is a tough one
- how to email sheets
- How to Stop the Update Dialog from Appearing?
- Replacing #DIV/0! WITH "0"
- Help
- Cell update
- Pivot Table fields
- excel - identify and count the number of unique entries in a list
- Need to Change Column of Telephone numbers to just 10 characters
- Editing/Copying Drop Down List
- VLOOKUP - Row names not unique
- any idea?
- Excel 2000/XP/2003 cell limitations
- need a macro which can combine 2 excel sheets data
- VLOOKUP - Row names not unique
- hyperlinks
- Formula for returning values if true or false
- Match won't match until I click into a cell then hit enter
- forcing recalculation of cell contents
- Excel 2000
- Re: LIST OF COMMANDS TRANSLATED
- macro to combine data from 2 different excel workbooks
- Re: Combo Box drop down list
- Return a max value of a column
- No Security Tab
- Excel asks to save even when no changes made
- Macro-error 400- macro doesn't work on other computer
- how to auto open file when starting excel?
- Max filesize
- again with the timer thing!!!
- unique record identifiers
- Change Cell Entry To Uppeercase
- Comparing files
- numbering rows
- Re: writing code for an option button
- text to excel
- Excel data not showing when opening file from explorer
- Calculating Sales Tax with the Paste Function
- splitting names into columns
- Rounding off Formula.
- Re: Sort Worksheet rows by color
- i need to add a row between each line of data
- Re: IF Function
- need to exceed nesting limitations
- countif links to another workbook not working
- Combination Delimeter
- Sorting In Excel
- How to delete rows containing one duplicate record
- Insert Row Every Other
- custom header..why doesn't the "AMPERSAND" show up when printing?
- Calling the Row Number?
- Merge cells
- macro to find out the last cell in a range
- default number of copies to print
- Excel data not showing when opening file from explorer
- Link "error message"
- Cell Formatting Colours by Value
- Applying a percentage increase to dollar figures throughout a workbook
- Can't open file
- Re: Calculate Problem
- Using both Landscape and Portrait page formats in the same sheet.
- optioncutton and focus
- sumif not equal problem
- How to display ALL text within a cell
- Autofilter doesn't work past blank rows
- Complex Conditional Formatting
- Re: LIST OF COMMANDS TRANSLATED
- Excel Dynamic Linking Problem
- Window problem with multiple files
- Selecting a command button whilst under a picture
- Certain sheets print really small
- Inserting an object....HELP!
- Excel QueryTables - Data Retrieval
- Help Conditional Formatting
- How to remove a line break within a cell
- Attempting to sum criteria in multiple columns
- open excel for same instance in command prompt
- printing misalginment errors in Excel
- QueryTables - Retrieving Data
- Text won't wrap - even when I check "Wrap Text" box
- Re: If functions
- Re: Transposing
- Re: Default column width in Excel
- Unprotect Excel 2002 row groupings in protected worksheet
- Permission to use object denied when lauching Excel
- Re: Validation list
- How Can I hide unused Rows in Spreadsheets
- Delete Filtered Rows
- Disappearing worksheets
- Re: Default column width in Excel
- How do I add something other than numbers??
- Re: LIST OF COMMANDS TRANSLATED
- Getting a € in Excel '97
- Row Height
- Quattro-Pro
- How can I stop a calculation when a total reaches a maximum value?
- Paste Excel Object
- Re: Validation list
- Fixed Character (alpha) length
- How can I search/replace weird command in text imported from Summation database?
- Missing Title Bar & Icons
- Re: Making "found" cells more visible
- How to make numbers (assumptions) show as different color...
- Pivot table greyed out in Data menu
- excel file is locked
- Barcodes
- How will I do Excel user-defined function to extract letters from string
- Copying multiple cells
- How to "clone" or "duplicate" cells & their formulas...
- Disable Copy & Formula Toolbar
- Unable to divide number in excel
- Having problem with simple division in excel
- automated email
- sumif
- Error message "File not loaded completely"
- Scrolling in Excel worksheet
- Automatic Calculation
- search value on base of 2 criteria
- Importing Text Files
- Question re: TODAY or NOW functions
- macro to find something in column A and delete 5 rows below it
- Simplify formula in Aspen Data Browser Add-in
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.