General

excel cells changing to "#VALUE!" whenever another file is opened
I have an excel file and formulae in two of the columns is changing to "#VALUE!", whenver a new file is opened and cells updated with data in the new file. All other cells are not effected and the only difference is, these two columns have Vookup function(to another sheet in the same file only).Also, pressing F... 9 Mar 2010 20:23

Excel shortcut keys
Are there shortcut keys for increasing and decreasing font size in a cell? ... 10 Mar 2010 08:36

Multiple conditions using greater than or less than.
I am trying to create a formula to help me with the below scenerio. I need to calculate how many days of PTO time someone would get based on years of service. the years of service cell is less than 2, the employee gets 11 days of pto if the years of service =2 or anything up to 3, the employee gets 16 days of ... 9 Mar 2010 16:58

Refresh pivot chart when info in a cell changes
To all, I am looking for help with a Macro. What I ultimately want to do is refresh a pivot chart when the user makes a selection from a list (in a data validation cell). For example, I am an end user that selects my territory from a "drop down". The pivot chart will update to the information that is dire... 9 Mar 2010 23:46

pulling random data from another tab in spreadsheet?
On main page of spreadsheet I have space for names and addresses of third party agencies we use. A separate tab (called Third Parties( contains the full contact information for the various agencies. Is there a way I can input the post code (Zip code) onto the main sheet and for Excel to search the third party... 9 Mar 2010 15:50

macro - copy/add to another sheet
Hi, i need a macro that will copy datas from sheet1 : J5 ;D13 ;D14 ;D15 ;F15 ;E19 ;E20 to Sheet 2 to range A:G. But i need the macro to paste to first empty row that it finds. Every time i run macro, to add the informations to the next empty row. The ideea is to add informations so i can create a small database. ... 9 Mar 2010 15:50

automatic page break
Why won't the following macro work to create a page break - in particular it is giving me an error at the InStr line Sub b8Pagebrk() Dim theRange As Range Dim lastrow&, firstRow&, x& Set theRange = ActiveSheet.UsedRange lastrow = theRange.Cells(theRange.Cells.Count).Row firstRow = theRange.Cells(1).Row For x... 9 Mar 2010 14:40

Excel will not open in default file location
Every time I click open within Excel 2007 it always defaults to a folder called Sage Line50 instead of my default file location within documents. This has only happened since installing Sage Accounts software version 16 Has anyone got any ideas? ... 9 Mar 2010 13:32

Conditional formatting flag
Is there an accessible flag that indicates whether Conditional Formatting of a cell is active? I'd like to show a value in one cell based on whether a Conditional Format condition is active in any of a group of cells. ... 9 Mar 2010 14:40

(Invulformulier WK2010 + nieuwe versie.excel) [0/1] - "Deelnemer_invulformulier_WK2010.nzb" www.vmp-online.com (1/1)
=ybegin part=1 line=128 size=1127 name=Deelnemer_invulformulier_WK2010.nzb =ypart begin=1 end=1127 fi���J�������gL[XZLJ��������gL���WbLJih74fKnym~�zoJ���JzlvsmJLWYY����l��YYn~nJx�lJZXcYYoxLJL����dYY���X�������X���Yn~nY���Y���W ZXcX���Lh74f���J�����gL����dYY���X�������X���Yn~nY\ZZ]Y���Lh74JJf����J������gL����j���W... 9 Mar 2010 13:32