Log in

No account? Create an account

Previous Entry | Next Entry

MS Augh!!!

...First amusement will be wondering how many people read the subject and think "Manuscript" ...

Excel and I are having a -- discussion. So far I'm not sure who's winning, but I really don't think it's me. Finding myself a course in Visual Basic is looking to be more and more necessary for the sake of my hair. And it's not even anything major, it's simply knowing that something *must* be possible, but having no real clear idea how to make it happen, and not knowing where to find the answer. Half the time I'm not sure I'm asking the right *question*! AAAAAAAHHHHHH!!! ::jumps around fisting hair::

Right, now that that's out of the system... *sigh* I finally found how to link Excel charts to PowerPoint so things update automagically, without having to strip every chart (20 at last count) into seperate files. Don't know why it worked this time when it hasn't previously, but so be it. Too bad that wasn't the question I was asking at the time, stupid Help file. I'm still trying to get my base charts to update themselves when I enter data - they're rolling 12 month productivity charts, and the chance of errors creeping in is higher than I like - I get distracted, forget to update a chart's source data, and suddenly I'm getting people panicked far out of proportion to the issue. Not worth it. Plus I'm lazy, which is funny when you consider how hard I'm trying to make this work. Oy... I'm now trying to set Labels and use Offset functions, but for whatever reason I'm not getting them to work in the 20-chart file, although they work successfully in a single chart test. I'm sure it has to do with do with Excel 2003 trying to add the file name to the label in the data line's function. Ugh, I just typed that and I'm not even sure what I'm talking about. Feh... I'm starting to think this might all work better if I just start from el-scratch-o. It's entirely possible I botched a setting somewhere, threw in a hidden function or something, in some previous attempt to make the DAMN THING WORK!!

...And if not, I'll just have to stay secure in the knowledge that many things are possible if one just plays Hide The Column.



( 5 comments — Leave a comment )
Jan. 9th, 2008 01:33 am (UTC)
Brave, brave soul. To try to get two Microsoft products to be compatible with each other!

We won't talk about my battles with Word this morning and it's "automatic formating".
Jan. 9th, 2008 07:31 am (UTC)
I have found "Control-Z" to be very helpful in combating 'automatic formating' evil thing that it is. It basically undoes whatever the last thing it did.

Jan. 9th, 2008 07:24 pm (UTC)
Micros**t - Mixed blessing
Screw "two Microsoft products", I'd be happy if Excel worked all on its damn-own!! And indeed, the less said about Word, the better.

Ever get the feeling these programs were written so well for idiots that the middle-smart person gets screwed? Not the right kind of skilled enough to program around the issue, too smart to be happy with the base applilcation. We are Microsoft of Borg, you will be assimilated...

Sadly, I usually like MS stuff, exactly because I *don't* have to think about what I'm doing usually. There's just so little middle ground. On the plus side - I can do Excel training stuff at work and prove it work related. Wh00t! :D

Edited at 2008-01-09 07:36 pm (UTC)
Jan. 9th, 2008 07:29 am (UTC)
I guess my level of frustration sympathy depends more on which version you are using. The newer the product, the higher the sympathy. (I'm sorry, but 2007 should be sold with some lube, a lobotomy, or something to make the hurting stop.)

Having used both and become very familiar with them, shoot me a line and I'll see if I can help. Like I said, let me know what version you are using and I'll see what I can do.

As an aside, I'm rather fond of Excel. Powerpoint and I are at least on speaking terms. At least on anything old. What is it with me and old stuff? Luddite I am...
Jan. 9th, 2008 07:37 pm (UTC)
Careful, or the next time you come over may start with Voltron and end with you doing my work for me :)
( 5 comments — Leave a comment )