Recent content by Auger282

thank you!

We are starting to play with remote profiles.. and we're finding that when we log into our servers its pushing down the remote profiles as well. Is it possible to prevent remote profiles from loading on specific machines? ... we would rather it create a blank local profile to use on the...

We're having a little trouble with windows updating running when users log on in the morning. It seems to do a full WSUS scan when they boot slowing down everything else. Here are our GPO settings Check for updates every 22 hours Configure auto updating - 4 auto download and schedule the...

Looks like this http://www.velocityscape.com/Help/images/img00021.gif but that is an sql pull.. and thats not me

Turn on your External data tool bar then setup an external data pull Data -> external data -> New database query Databases-> excel files -> OK Find the source file then in the "query wizard - choose colums" grab the sheet you want. Next I do not do any query I want the whole thing.. so I...

Everything is pulled into the destination as a General type of cell....

what I've done to test this is clear out the data that is already on the destination sheet and click the "refresh data" button on the "external data" toolbar. The data gets pulled in as described above.. 1/2 the sheet comes in. It appears that all the vlookup data comes in fine but the sumif...

yes the R drive is where both the source and the destination workbooks live

I agree going forward currently all users working and non working have the same drive mappings I may end up setting this up as a linked workbook.. but its annoying because it works on 2 systems and not on mine and the person who needs this... there has to be a reason and a solution

This is what is listed under "Edit OLE DB Query" Connection: Provider=Microsoft.Jet.OLEDB.4.0 User ID=Admin Data Source=R:\SOURCE.xls Mode=Share Deny Write Extended Properties="HDR=YES;" Jet OLEDB:System database="" Jet OLEDB:Registry Path="" Jet OLEDB:Engine Type=35 Jet OLEDB:Database Locking...

So there's ONE destination workbook, that if TWO users open and refresh, see all the data, but everyone else does not? YES? -Correct... independently.. not at the same time So is it an IMPORT or a Database QUERY? Its got to be one or the other. Database query is what we are using.. however...

one to one in Excel 2003 Data - Import External Data - Import data or Data - Import External Data - New Database Query its a pull grabs the source sheet and pastes it in the destination sheet where I specify

I have a source workbook that does all sorts of magic within it self that works on everyones machine. The destination workbook is trying to use the External data function to pull a spreadsheet from the source workbook into the destination workbook. Once that source sheet is pulled in all sorts...

I have a really pain issue right now. I'm thinking its a version issue or some hidden option somewhere. Let me start this with it works on two people's computers and not on mine or anyone elses.... I'm trying to pull a whole spreadsheet into an different workbook using the external data...

They can see the server and they are reporting to the server as specified.. we can see them on the server and all of their updates have been approved to be rolled out but they arent getting there... ------------------------------ 2007-10-11 16:30:06:580 1960 684 AU Triggering AU detection...