The only site I'll ever need...

[Indolent Reader]

Setup is this: it's the "2" on the dual receiver (so no physical receiver).  The coax is plugged directly into the tv.  Lines are about a half-inch thick (with another 1/2 inch between them) (30" tv) that slowly move downward.

[Richard Chuggar]

Setup is this: it's the "2" on the dual receiver (so no physical receiver).  The coax is plugged directly into the tv.  Lines are about a half-inch thick (with another 1/2 inch between them) (30" tv) that slowly move downward.

Get your parents to get you a better dish. 

[Wheezer]

Setup is this: it's the "2" on the dual receiver (so no physical receiver).  The coax is plugged directly into the tv.  Lines are about a half-inch thick (with another 1/2 inch between them) (30" tv) that slowly move downward.

You said "upward" before. It probably doesn't matter. First, disconnect everything else that might be connected to the TV and see if the bars disappear. When that doesn't work, install a common-mode choke as close as possible to where the coax connects to the TV. You can make one by getting an FT-240-43 toroid and looping the coax through it five to ten times. Another option is to get a couple of 75-to-300 ohm impedance transformers, connect the spade-lug ends, and put the assembly into the feed line (this won't work unless they're internally isolated, but Radio Shack is easy with the returns if you don't massacre the packaging; you'll need an extra piece of coax).

[Indolent Reader]

Thanks.  Disconnecting does nothing (picture stays the same). 

[Dr. Nguyen Van Falk]

Setup is this: it's the "2" on the dual receiver (so no physical receiver).  The coax is plugged directly into the tv.  Lines are about a half-inch thick (with another 1/2 inch between them) (30" tv) that slowly move downward.

You said "upward" before. It probably doesn't matter. First, disconnect everything else that might be connected to the TV and see if the bars disappear. When that doesn't work, install a common-mode choke as close as possible to where the coax connects to the TV. You can make one by getting an FT-240-43 toroid and looping the coax through it five to ten times. Another option is to get a couple of 75-to-300 ohm impedance transformers, connect the spade-lug ends, and put the assembly into the feed line (this won't work unless they're internally isolated, but Radio Shack is easy with the returns if you don't massacre the packaging; you'll need an extra piece of coax).

I'm pretty sure Wheezer just taught a Sox fan how to build a dirty bomb.

If the BLOGWARS don't take this place out, surely the Feds will.

[MAD]

Setup is this: it's the "2" on the dual receiver (so no physical receiver).  The coax is plugged directly into the tv.  Lines are about a half-inch thick (with another 1/2 inch between them) (30" tv) that slowly move downward.

You said "upward" before. It probably doesn't matter. First, disconnect everything else that might be connected to the TV and see if the bars disappear. When that doesn't work, install a common-mode choke as close as possible to where the coax connects to the TV. You can make one by getting an FT-240-43 toroid and looping the coax through it five to ten times. Another option is to get a couple of 75-to-300 ohm impedance transformers, connect the spade-lug ends, and put the assembly into the feed line (this won't work unless they're internally isolated, but Radio Shack is easy with the returns if you don't massacre the packaging; you'll need an extra piece of coax).

I'm pretty sure Wheezer just taught a Sox fan how to build a dirty bomb.

Probably wouldn't be a first.

[Indolent Reader]

I'm definitely not smart enough to figure out that suggestion (though I appreciate it). 

[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?

[morpheus]

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.

[PenFoe]

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.

Couldn't you just password protect the source file and hide columns/rows so that they can't see the data?

[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.

Couldn't you just password protect the source file and hide columns/rows so that they can't see the data?

To protect sensitive data, just hide those columns? That's Pen's suggestion?
Just use the white-font, white-background option dude.

[Slaky]

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.

[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.

[PenFoe]

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.

Couldn't you just password protect the source file and hide columns/rows so that they can't see the data?

To protect sensitive data, just hide those columns? That's Pen's suggestion?
Just use the white-font, white-background option dude.

No, my suggestion was to password protect the document so that they couldn't be unhid.

[Slaky]

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.