Search results for query: *

simply , the account doesn't appear in active directory users and copmuter , but appear in global address list in exchange and when a make search in active directory

Hi all , i have restored DC after disaster , the domain dom1 is empty except ABC user , after restoration i found that a user account appears when i make search in active ditectory , using active directory search , if i search in each domain this user does not appear , when i try to delete...

Dear All ; Can you help me to solve this problem in exchange 2000 Messaging systems . Environment description : Active directory with tow domains , Acorp (root)and Bcorp Exchange Server is joined to Bcorp domain. All domain controllers are in the same site . FSMO and global catalog servers...

Dear All ; Can you help me to solve this problem in exchange 2000 Messaging systems . Environment description : Active directory with tow domains , Acorp (root)and Bcorp Exchange Server is joined to Bcorp domain. All domain controllers are in the same site . FSMO and global catalog servers...

thank you ,but i need to convence my CIO by competitive study,do you have?

Dear All : greeting i'm planning for enterprize backup system for my corporate , i have more that 1TB daily backup ,and i want to evalute the current backup software such as ARCServe, Veritas ..etc , to choose one of them . any one have a new coparison study , a mong backup sotware will be...

PH Frustrating, but correct. Thanks for the pointer. Regards Nick

Hi "Which code?" is a another question I need answering but I was trying. WorkSheet("Sheet2").Activate ActiveWorksheet.RefreshAll Just tried your Application.Calculate suggestion but pivots did not refresh. Nick

Hi "Which code?" is a another question I need answering but I was trying. WorkSheet("Sheet2").Activate ActiveWorksheet.RefreshAll Just tried your Application.Calculate suggestion but pivots did not refresh. Nick

Hi I have some code running under the Worksheet_Change function in object Sheet1 in a workbook. This code updates cells in sheet1 when data is pasted into sheet1. This works fine. As a result of changes to sheet1 (occuring when user pastes data) I want the Pivot tables in sheet2 to refresh...

Skip Apologies, I was not being clear. First time the user uses file he opens and the query, gets the data, and the formulas automatically fill to the row number of the data paste - perfect. Next month user opens file again. The query updates but it has less rows than previous month = excess...

Skip Don't understand your last comment. First time the user uses file he opens and the query gets the data and fills the formula the - perfect. Next month user opens file again. The query updates but it has less rows than previous month = excess forula rows (generated from previous months'...

Hi have got it to work, thanks. This is a useful technique. However 1) there is the problem with the add-in 2) solution does not delete 'excess' formula rows. Part 2 is my main issue as the number of formula rows (and the resulting size of the ranges) are having a big impact upon speed and...

Skip Am just running through this and I hit what I think could be my first hurdle. Miscrosoft query was not installed for me (though it now has). Users will freak if they see the same issue. Will anyhow update you when I've got this to work... N

Skip A-SalesCo B-SalesBrand 1 C-Mill D-G/M2 E-Cal.year / month F-MonthOrigInv G-Curr H-Tons I-Turnover Value J-Turnover Value Main Curr K is an empty column L-months M-string1 N-string2 O-curr string1 P-curr string2 Q-tons R-EUR value S-curr value T-gsmtons These headers in ROW2 (but no reason...

Evening Skip 1) Disappointingly, my skills don't stretch to queries 2) This workbook will be distributed to the 'users' for them to run the BW query (with their user restrictions) and copy paste in the data to get the 'summary' they need - the users are infinately more useless in Excel than I...

Tony Yes, all the relevant cells will be non-empty Yes, excess formulae will need deleting as well. I was thinking of something along the lines of: [...on pasting of new data] Clear contents of cells G4:J65xxx (ie end of sheet). Copy G3:J3 and paste to G3:Jx (this x being the row number...

Skip Reason for this 2-step process is I cannot get required groupings from the original data source (SAP Business Warehouse). Therefore my process is to get 'raw data' from BW (pasted to cols A:E), lookup the necessary groupings (cols G:J) and summarise in a seperate sheet (using mainly SUMIFs...

Tony The user may first delete the 'old data' and do the paste, or do the paste and then delete the excess lines. Either way, lets assume the data present is the data were working with. ie the last row is always the row reference we want. Nick

Hi I have a worksheet where users will paste a block of data into columns A:E. In columns G:J there are a bunch of formula refering to columns A:E (mainly concatenations and vlookups). Row 1 is empty and Row 2 is headers. Because the data paste that is made by the user can vary in terms of the...