Search results for query: *

Okay..cleaned up the files and got it down to 69.8MG. It is a PentII/4000, so should be able to handle this. Cleaned temp file, but don't know where the .chk and ~*>* files are. I think the files are so big (a) because there is 755 items per worksheet x 31 worksheets x 10 workbooks; all linked...

Okay, the Folder (which has all 10 files) is 70.5 MB. The PC is a Pentium Pro(R) (it comes up Pent II in the start up, I was told), with 128 RAM, 75% Free. I would love the info on cleaning up the hard drive..but I do know about scan/defrag/empty temp. files. Is there more? And do you...

Thanks! Just got in..will get that info in a few! Jackie

I have set up a very simple workbook with 9 others linked to it, each with 31 pages. We are having several problems with it, the first of the two major being the autocalculation control has turned off on it's own a couple of times, and I know they were all turned on because of this happening...

No, it doesn't do it. Example: I'm in Aug.xls, save it as new.xls, change name to Sept.xls, linked to Aug.xls; make new workbook from Sept.xls, change name to Nov.xls, and the link is still to August.xls, not to Sept.xls, which is where I need it to go. Thank you for your help! Jackie

Thanks! The only problem is that I will create a new workbook monthly; so each month the link will change to the previous month (the one I created it from). I can use Links/ChangeSource but was hoping to make it more automatic, i.e. when I use the control. Jackie

I've set up a macro in Excel linked with a control button that will SaveAs when clicked and will make a duplicate of the workbook. My problem is that I have linked the workbooks together so that totals will carry from one month to the next; what's happening is that the new workbook is still...

Okay, I'm down to this one thing. This is what I have in the macro to go to the previous workbook and populate the columns: Range("H5").Select ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!R5C10" ActiveCell.FormulaR1C1 = "=[Jan.xls]Week4!RC[2]" What I would...

Now that was embarrassingly easy :). My only question that each workbook is linked to the previous one (to carry running totals forward) and what is happening is that when I make a new one, it doesn't update the link (i.e., it looks for data in the original workbook). In other words, when I...

Thanks...got my cup of hot chocolate laced with coffee, opened up Help, and will tackle it :). This is my first VBA, and I know that once I do one, it will be simple, but the first one around always goes over my head for awhile :) Will be back at you, I'm sure ;) Jackie

I would like to create a "SaveAs" (or whatever you suggest) control button that will 1). create a new worksheet in a folder *and* 2). remove values from columns 1&2; 3). replace values from columns 5&6 to 3&4, 4). and remove values from columns 5&6. I know how to do it...

Just found one more weird thing...the calculation *was* turned off in 4 of 10 workbooks that I have linked together. No, the person is barely computer literate, so I know he wasn't changing things..he's overly careful with this. I will definately reload the software and see what happens. We...

No, I can uninstall and reinstall. I will try it on Monday if the problem continues...however, I would like to avoid uninstall if just reinstall will do. What's SR2a? Don't know all the techie language..yet :) Thanks! Jackie

Nope, it's there. I even had a more experienced person look at it and she threw up her hands in frustration. And the entire workbook from January suddenly stopped calculating. What's even weirder is that if we typed in the formula again, it would work for one calculation, then quit. And...

Thanks...checked it, already set :(. Any other ideas? Jackie

I have a small workbook I set up on two computers; on one it suddenly stopped adding two columns together; the other the function works fine. It was just noticed today; what's even weirder is that the previous month's workbook has also suddenly stopped calculating. Could this have anything to...

This is really great! Questions: I want the controls to be a different color than the background (background,stone; controls, gray) but I would love to have the highlights, too, but can't seem to get it to work that way. I also tried the above code, but I must be missing some OnGotFocus code...

Thanks! That is it...you highlight (shift, click to end) the pages, then it automatically carries it through the workbook!!! I knew it couldn't be set up to not do something like that! Thanks again! Jackie

I have a workbook that has 32 worksheets in it...inventory...and I want to delete certain items across each sheet (one for each day of the week). I have the row formula so they equal the total sheet so that when I did corrections it would do it for all the sheets; however, when I go to hide the...

One more time..I keep click the wrong links :)ended up in SQL last time! I already checked with the other forum (Office General) and was directed back here :) Easy questions, probably, but finding the answers isn't :) 1) Can I get Excel to automatically add data in the same cell as it is...