The only site I'll ever need...

[BH]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

Especially here where they post your numbers anywhere your eyes might wander off to so as to ridicule the low end people and tell the high end people to do better next month.

Ah, sales.

Can you post Oleg's sales numbers?

[Quality Start Machine]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

Especially here where they post your numbers anywhere your eyes might wander off to so as to ridicule the low end people and tell the high end people to do better next month.

Ah, sales.

Can you post Oleg's sales numbers?

420

[Oleg]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

Especially here where they post your numbers anywhere your eyes might wander off to so as to ridicule the low end people and tell the high end people to do better next month.

Ah, sales.

Can you post Oleg's sales numbers?

Joke's on you!  I'm not really in sales anymore!

[Jon]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

Especially here where they post your numbers anywhere your eyes might wander off to so as to ridicule the low end people and tell the high end people to do better next month.

Ah, sales.

Can you post Oleg's sales numbers?

Joke's on you!  I'm not really in sales anymore!

Also, you wouldn't remember them anyway.

[Brownie]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

It's not the other salesmen's numbers I'm worried about.

[Dr. Nguyen Van Falk]

I know I should probably buy some real software, build a XML database, etc., but I'm a caveman and I need your help:

I have set up a spreadsheet (a simple Excel file; as I said, I'm a caveman) tracking the various sales goals for our sales reps and want them to see their own progress. The thing is, the source spreadsheet has a bunch of proprietary information (not to mention the performances of their peers) that we'd rather not share with them. Thus, the source sheet is on a file server in a folder restricted only to management.

I set up a simple spreadsheet for each salesperson (yes, the formulas are hidden and the cells are protected) that would track his or her progress. Each file is in the respective salesperson's server folder, to which they have access.

Now here's the problem: because they are restricted from the source file, these worksheets will not update for them. Is there a macro/VB code or any other type of workaround that would let the spreadsheet update automatically for them but not give them read access to the source file?

I hate to disappoint you... Excel doesn't allow you to just link to the source file since they can't access it.  You're probably best off having some sort of nightly job run (use WinCron, maybe?) in which the file for each individual salesman is updated from the source.  Or, you could use a database solution - you can control a lot more around access to data that way.

Sexist.

Am I the only who thinks it's a bit weird to be worried about salemen seeing other salemen's numbers?  Every sales job I've ver had we've seen what everyone else is doing.

It's not the other salesmen's numbers I'm worried about.

Which is why TJ wasn't mentioning them.

[Dr. Nguyen Van Falk]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

[Indolent Reader]

I renewed mine at the Loop express facility about three 1/2 years ago, so it might have changed since then, but I was in and out in around 20 minutes.  Granted, this was at about 10:30 in the morning, but it was definitely quicker.

[MAD]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

No, but now that I've read this, I'm going to give it a shot!  My license has been expired for almost 2 months now.

Thanks, Desipio!

[Gilgamesh]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

No but now that I've read this, I'm going to give it a shot!  My license has been expired for almost 2 months now.

Thanks, Desipio!

Now both of you have a chance to get the new gheyass Illinois driver's license.  Congrats.  I still have one more year on mine before it expires, so that state might change the design again, like it has like 3 times in the past decade or so.

[flannj]

It is faster but go before the lunch hour.

[CBStew]

In California we get to renew on line two times in a row.  The third time you can make an appointment at the DMV.  At my age, however, one must come into the DMV so they can scrutinize the applicant in person.  I think that is a good idea.  (I have an appointment on March 10.  The ambulance will bring me directly to the disabled person's entrance)   

[PenFoe]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

So, I haven't lived in Chicago in 7 years, but I have been to both of these facilities and the Elston one took about 2 hours and the Express Loop facility took about 20 minutes.

[Chuck to Chuck]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

So, I haven't lived in Chicago in 7 years, but I have been to both of these facilities and the Elston one took about 2 hours and the Express Loop facility took about 20 minutes.

Noon is a bad time to go.  Everyone else thinks to go at lunch time.

[BH]

I have to go renew my driver's license tomorrow.

Figure if I go to the Elston DMV mid-day it shouldn't be too much of a hassle.

The notice I got from Jesse White, though, urges me to give the Express facility in the Loop a try. Has anyone ever renewed a license there? How "express" is it?

So, I haven't lived in Chicago in 7 years, but I have been to both of these facilities and the Elston one took about 2 hours and the Express Loop facility took about 20 minutes.

Noon is a bad time to go.  Everyone else thinks to go at lunch time.

No shit? Thanks Chuck!