Not Enough Memory opening 2nd spreadsheet

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Current bi-weekly total In my worksheet, Column A1 has project start date and A2 to A3000 has subsequent dates based on A1. Column B has data. After each 14 days, there is bi-weekly total. I would like to add a row on top, which will show me bi-weekly total for the current week. So, let's say, if project start in January 6, 2008, and if today is March 14, I want be able to see the most current bi-weekly total. Is there a way to do that. I was able to do "Year to Date" total by just simply adding those biweekly total. Since, it is a long sheet, I have scroll down to find out current bi-weekly total. I want avoid that. So, the most current bi-weekly total always will be in top row. Thanks in adavance. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770127
  - 2
    - Hiding Results of Answers for a Quiz Hi, Looking for some help here please. I currently have a quiz set up, with simple questions in the A Column. The delegate places their answer in the B Column, and the C Column then states whether it is correct or not. Used the following formula : =IF(B2="A","CORRECT",IF(B2="","",IF(B2="B","INCORRECT"))) What I need, is for the formula to only be applied once the delegate indicates that they are finished the whole test. (i.e. clicks a cell marked as a "Finished" button). I need to know 2 things: 1. How to set up a cell like a "finished" button for example. 2. How to get the formula not to apply until the finished button has been selected. Any help would be greatly appreciated!! Thanks! Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770126
  - 3
    - Shared document will not open for user Hi, I have a user who is using Excel 2003 on Windows XP. She has a shared workbook that is password-protected on a shared drive. Everyone who has access to the spreadsheet can open it, except for her. It is only this spreadsheet. Her password works fine on other spreadsheets and documents. (This is Excel-level password protection, Tools > Protection >Protect Workbook. ) There is no error message. She enters her password, and a blank instance of Excel opens. Any ideas about how to fix this? Thanks! Kim Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770121
  - 4
    - auto fill rows in Excel 2007 I have a worksheet containing plant information. Each plant has a unique code in column 1. The adjacent cells in that row contain information about that plant (size, color, latin name, etc.) When I create a list for a new job, I'd like to be able to input an existing code in column 1 of a new worksheet (or even blank space in the existing worksheet) and have Excel 2007 automatically fill in the adjacent cells. Any help would be greatly appreciated. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770114
  - 5
    - Delete duplicates? I have the following code below. How can I include sheet "customers2" also in the code? Private Sub CommandButton99_Click() Dim iRow As Long Dim FirstRow As Long Dim LastRow As Long With Worksheets("Customers") FirstRow = 2 'headers in row 1 LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For iRow = FirstRow To LastRow Step 1 If Application.CountIf(.Range("a1").EntireColumn, _ .Cells(iRow, "A").Value) > 1 Then 'it's a duplicate .Rows(iRow).Delete End If Next iRow End With Unload Me End Sub thank you -- kk Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770112
  - 6
    - Recording Macro Dumb question.... If you have recorded a macro, later wish to add 1 or more steps to it, is there a way to just add to the recording, without having to write or cut and paste code into it? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770110
  - 7
    - Obtain numeric from alphanumeric string What is the easy method of obtain numeric from alphanumeric string in an excel column:- ab 0.25 I want 0.25 jds 0.125 I want 0.125 Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770098
  - 8
    - Cell Format on Imported Data I have imported data from Oracle (using programing, not import). This is a large file and it brought all numbers over as text. When I choose the column and fomat as number nothing happens. I have to choose each cell change format and enter. This is impossible as there are thousands of numbers to change. HELP.... Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770096
  - 9
    - Finding files in a folder. Variable not defined error. I am getting a variable not defined error on this line "For Each c In lstrng.Cells" and I can't figure out what that means. Any ideas? Set lstrng = Range("A2:A" & Range("A2").End(xlDown).Row) Set fs = Application.FileSearch 'Use Microsoft Scripting runtime. Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.getFolder(UserForm1.txtFolder.Value) 'Check type of file in the folder and open file. For Each c In lstrng.Cells c.Activate If c <> "" Then With fs .LookIn = f .SearchSubFolders = True .Filename = c.Value If .Execute() > 0 Then For i = 1 To .FoundFiles.Count c.Offset(0, i + 1).Value = .FoundFiles(i) Next i Else 'MsgBox "There were no files found." End If End With ElseIf c = "" Then Exit For End If Next Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770090
  - 10
    - Formula for calculating time off My company is going to a PTO or Paid time off program and employees will start to ecru time bas3ed on years of service. I am having difficulty creating a spreadsheet to do this becasue of all of the variables involved. I was hoping maybe you woudl have some ideas here that I could poach. Here are the variables. It is all based on calendar years. So if a person started in 2007 on 12-30, as of 1-1-2007 they woudl be at the rate of 1 year since this is when their anniversary falls. Not only are people ecruing time, but there is also a max time that they can have. I will put in a crude table to expalin. Years Weekly Accrual Max hrs 0 1.538461538 120 1 2.153846154 152 2 2.461538462 168 4 3.230769231 248 Then people will use time out of this banked time. I have formulas that will put the time in, but will not change for the next years eccrual rate. Please Help, Jay Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770088
  - 11
    - consecutive dates i have a scheduling spreadsheet, and need a way of having the dates run consecutively instead of having to manually type each one, i.e mon 03/03 tues 04/03 weds 05/03 thurs 06/03 fri 07/03 mon 10/03 tues 11/03 weds 12/03 thurs 13/03 fri 14/03 and so on and so on, thanks, marie Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770083
  - 12
    - Location of MS Query Application I often use MS-Query 4 extracting data from closed files and run the queries. Where can the MS-Query application be located as I want it's Icon/shortcut 2 be made? Thanx -- Best Regards, FARAZ A. QURESHI Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770082
  - 13
    - Filtering in Validation I am creating a scheduling system for an EMS service. I have a single list of employees (AA:AB) that I can use to create a LIST via validation. AA:AA = Employee Name AB:AB = Certification ie P=Paramedic, I=Intermediate, B=Basic, D = Driver I want to filter based on certification in the validation option so that only paramedics appear for the medic shifts, etc. Is there a way to filter within the validation or do I have to create four separate lists? Thanks, Les Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770080
  - 14
    - Macro - Insert column with VLookups Hi All I need to analyse out a transaction listing based on the account codes. I have set up VLookup tables but I would like to have a macro that would insert the columns with the formulas. The range will be dynamic. E.g. Account Number Insert 1 Insert 2 Insert 3 Amount 111 Vlookup(1) Vlookup(2) Vlookup(3) 222 Thanks in advance Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770073
  - 15
    - linking and transposing two worksheets I am having trouble creating a link between two worksheets. I have essentially copies of the same worksheet but one is horizontally arranged and the other is vertically arranged. I want to be able to update either one of the worksheets, and then excel to automatically update the other. I have tried linking them but as in one the data is horizontally arranged and the other is vertically arranged it doesn't work. I have tried creating a new workbook and using this formula; =INDEX(.....COLUMNS($A:A),ROWS(1:1)) but this only seems to coppy and I cannot update both sheets by inputting data into another? Does anyone have any other suggestions? Thank you!! Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770071
  - 16
    - mouse locked in "drag mode" Here's an odd situation that I've run into in my excel '03...sometimes, not all the time, the mouse will lock itself almost as if I'm holding down the left button and dragging it around. I can't get it to let go of the origin cell and wherever I move the mouse from the origin cell it "paints" the drag pattern. Anyone ever run into this one before? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770067
  - 17
    - Scheduleing Employee Twice I just recently posted with a question about a formula to not be able to schedule an Employee if they requested a day off, and it worked great. Thanks to T. Valko. They gave me the formula =MATCH(A3,B$5:B$23,0) to assist on my question. I was wondering if I need to use the same basic formula for my next problem area. I have tried using it, but to no prevail. Question: In cell B4:B23 I have a list of all the Employees for that DAY SHIFT and what times they come in, as well the position they work. (a drop down menu is in use to select employee names) In cell H4:H23 I also have a list of all the employees for that NIGHT SHIFT what times they come in, as well as position they work. (a drop down menu is in use to select employee names) I would like to know if there is a way to prevent a user from scheduleing the same employee twice in a day in two different positions. We have had problems in the past where the Manager scheduled an employee twice in the same day, and we were left short handed. Of course we have some employees work between shifts so they are oviously going to be on both shifts; as well as splits. (no problem there is it shows that we have an employee scheduled twice in that sense). Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770066
  - 18
    - comment (with little red triangle) appearing in pivot table Hi, if i insert a comment in my source data (using the 'insert commment' function with little red triangle), and then do a pivot table on that data, is there a way to have the comment appear with the data in the pivot table?? I can understand it would be hard when data cells are summarised or totalled etc in the pivot table, but where individual data cell infomation from the data source is presented in the pivot table, i just thought there should be a way to have the 'comment' to appear as well as the cell information. I'm using excel 2003 thanks in advance Peter Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770054
  - 19
    - macros help... I have a vertical list of 4 digit numbers that I want to add a zero(0) to the beginning of the number. For example a number might be 3324 and I want to add a 0 to the left of the 4 digits to end up looing like 03324. The problem is this: This vertical list of numbers is almost 1200 lines deep. Some of the numbers in this list are already 5 digits, whcih is what I want. I need every number on each line to be 5 digits long. I did create a macro to add the 0 to the 4 digit number, then drop down to the next line, but when I run the macro again for the next line, it changes the number on the next line to the same number on the line above. I want to be able to start in a cell, hit Ctrl G and have it add a 0 to the 4 digit number in that cell, then drop down a line and allow me to hit Ctrl G to do the same thing to the 4 digit number in that particular cell. The left column in the spreadsheet looks like this: 2345 2365 2476 2490 And when I get through I want it to look like this: 02345 02365 02476 02490 What it is doing now is this: 02345 02345 02345 02345 It's changing each number in each row to look exactly like the number in the first row. I would appreciate any help anyone can offer. I used to use Lotus 123 and did not have this kind of problems. Thanks in advance for any advise or solutions. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770049
  - 20
    - Excell 2003 / 2007 I downloaded the test-drive version of Excell 2007. Since the expiration has expired, all my Excell files are saved as 2007 as read-only. Does anyone know how I can convert those files back to 2003? I read a posting that said save them as a 2003 file. How do I do that? I appreciate any assistance. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770047
  - 21
    - Name Conflict I recently install Office 2007. I have Excel files created in Office 2003 that I can not open. I get a message box: "Name Conflict" "name cannot be the same as a built-in name". Then below that message is: "old name: Print_Titles" ,then below that a box to enter "New name:" I'be tried everything I know. -- Roger Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770046
  - 22
    - how to filter spreadsheet by multiple variables? I know I can use autofilter to find certain criteria that exist in rows within the same column. Is it possible to sort by mutiple variables, like 2 or 10? Say I have a column with variables a-z. Is it possible to filter all the rows with b,c, j, p and x? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770044
  - 23
    - is there a way to make info from one cell migrate to another cell I'm not sure how to describe this. I have a row of information and some of the cells need to change daily. I'd like to keep a record of the info for the past couple of weeks. Right now I'm doing the tedious work of cutting and pasting the info in each cell before I change it. is there a way to get the info from one cell to migrate to another cell immediately after I type it, then the next time I type in the cell for the info to migrate to the next successive cell? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770039
  - 24
    - Error when opening an excel file I get an error whenever I try to open an excel file attached to an email or from the folder (if I open my computer or my documents). In both cases is says the that file cannot be found. I do not have a problem opening an excel file if I open the excel program first. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770037
  - 25
    - How do I make ETrade's DDE addin work in Excel 2003 and Vista? I used to use ETrade's DDE (Dynamic Data Exchange) addin with Excel 2003 on Windows XP, but now that I have upgraded to Vista, the ETrade add-in menu no longer loads up, even though I can see the add-in in Tools-Addins. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770034
- Next
  - 1
    - Macro in excel/ced I have a macro in Microsoft Excel listed below. I need for it to repeat until xxx is entered. Any help will be appreciated. Sub OptionExplicit() ' ' OptionExplicit Macro ' Macro recorded 3/10/2008 by Student Financial Aid ' Dim vName As String Dim vAddress As String Dim vCityStateZip As String Dim vPhoneNumber As String Dim vEmailAddress As String Dim vRealEstateAgentAndCompany As String Dim vxxx As String vName = InputBox("Please type in your name?") If vName = "xxx" Then Exit Sub Else vAddress = InputBox("Please enter your address?") vCityStateZip = InputBox("Please enter City, State and Zip?") vPhoneNumber = InputBox("Please enter your Phone Number?") vEmailAddress = InputBox("Please enter your Email Address?") vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent and Company?") Worksheets("Sheet1").Range("B1") = vName Worksheets("Sheet1").Range("B2") = vAddress Worksheets("Sheet1").Range("B3") = vCityStateZip Worksheets("Sheet1").Range("B4") = vPhoneNumber Worksheets("Sheet1").Range("B5") = vEmailAddress Worksheets("Sheet1").Range("B6") = vRealEstateAgentAndCompany ' Range("B1").Select Range("B2").Select Range("B3").Select Range("B4").Select Range("B5").Select Range("B6").Select vName = InputBox("Please type in your name?") vAddress = InputBox("Please enter your address?") vCityStateZip = InputBox("Please enter City, State and Zip?") vPhoneNumber = InputBox("Please enter your Phone Number?") vEmailAddress = InputBox("Please enter your Email Address?") vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent and Company?") Worksheets("Sheet1").Range("B11") = vName Worksheets("Sheet1").Range("B12") = vAddress Worksheets("Sheet1").Range("B13") = vCityStateZip Worksheets("Sheet1").Range("B14") = vPhoneNumber Worksheets("Sheet1").Range("B15") = vEmailAddress Worksheets("Sheet1").Range("B16") = vRealEstateAgentAndCompany ' Range("B11").Select Range("B12").Select Range("B13").Select Range("B14").Select Range("B15").Select Range("B16").Select End If Application.Goto Reference:="OptionExplicit" End Sub Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770029
  - 2
    - Why are my page layout options grayed out? I am new to the 2007 version and cannot figure out why MARGINS, ORIENTATION, and SIZE are grayed out under the Page Layout tab. I have tried copying and pasting to new workbook but still not working. Any suggestions? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770022
  - 3
    - Adding to a formula I am trying to add a cell from one worksheet to a formula in another worksheet but it just shows the forumula in the total box instead of the figure what am I doing wrong? -- Jooles Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770021
  - 4
    - Comparing Spreadsheets - best practices I have two spreadsheets that contain names, addresses, telephone numbers, etc. of prospects. Both sheets have about 4000+- contacts. I want to compare the two and accomplish a couple things but i'll just start with the first and go from there: I want to see what companies are found on both lists so that i can compare the names and addresses and update one list against the other (one is new and one is old). Any ideas on the best way to go about this? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770018
  - 5
    - ROUNDING IN EXCEL I have a customer who wants calculations Rounded per the requirements of ASTM E29. Does anyone know if Microsoft Excel complies with ASTM E29 when numbers are rounded? Thanks Paul Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770017
  - 6
    - Running Clock This is what i need to do. i need a running clock that shows days, hours and min from 12-27-2007. im very new to this, so if you can help, please spell it out very well Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770016
  - 7
    - Total red Total Blue need help from you Hello I have conditional formatting =$$AA5="Red" format is highlight in red, second conditional format is =$$AA5="Blue" format is highlight in blue. I want to total all the cells in column D,that are highlighted in red and the result to go in cell N1 then Total all the cells in column D that are highlighted in blue and the result to go in cell N2 the column range is always A toZ and the total number of rows depends on the report rows Can someone , please help me with a macro. Thank so much Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770014
  - 8
    - Text wrapping in cells I have my text wrap set to work in my cell and it works fine but then suddenly decides to stop wrapping text arbitrarily even though the text above it is wrapped. Limiting the size of the statement does not seem to have an effect. Any ideas? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770012
  - 9
    - Form behind cell entries Good afternoon -- I would like to use Excel as a simple database, so that other users can fill out forms. Rather than retyping and formatting the form in Excel (or requiring them to print out a blank copy and reinsert it into the printer) I'd like to paste a picture of the form, perhaps making it transparent, and then writing code to fill the appropriate cells with the appropriate info. So -- can I paste (for example) an IRS W-9 tax form into Excel, making the blank parts transparent so I can align the boxes with Excel cells? I have pdf's, but can convert into other formats if needed. Thanks in advance. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770011
  - 10
    - Printing with cell borders MS Office 2003-Excel - when I print a sheet that has borders around the cells, as you move down the printed page, the bottom cell borders print above the data in the cell so it looks like the data has a strike-thru instead of the cell border. The top half of the printed page looks fine, but as you move down the page, the cell borders seem to "move" up while the data remains in place. This also happens if I don't use borders and use underline instead. Don't know what to do. Any suggestions appreciated. Thanks Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770007
  - 11
    - Validation List to fill adjacent cell with IF? I am trying to set up a drop down list (list is set up ok) that has the months of the year in it to correspond with a number for the month using IF, but it doesn't seem to work. Here is the formula I was trying in cell A2: IF(A1="January",(1))*IF(A1="February",(2))...etc. The value in A2 comes back as 0 or #NAME. Obviously this is not the way to set this up, but I am unsure how to make it work. Is there somewhere I can look this up or does someone have a formula to use? I use Excel 2002 and 2003. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 770006
  - 12
    - PivotTable Autoformat Is it possible in Excel 2003 to add in or replace any of the existing built-in PivotTable Autoformat templates without resorting to a 3rd party plug-in? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769991
  - 13
    - large function in non-continguous array? Thanks for any help. Is it possible to use the LARGE function in a non-continguous array? It doesn't seem possible. I got a couple arrays, all in the same column, but with rows in between them. Thanks again. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769990
  - 14
    - Strange formula problem Sorry for the vague subject line but I couldn't think how to summarise this problem in a few words. I've created a workbook to record how many hours I spend working on various projects. The workbook consists of a sheet for every week of the year and a totals sheet. The weekly sheets feed into the totals sheet via SUMIF formulas. The projects all have a unique code which are listed on the totals sheets and are entered on each week sheet if I work on that project in that particular week. On the totals sheet I have a column to enter how many hours are allocated to each project and a column which compares this number to the total hours worked on that project. This is where the anomaly lies. I have entered some test data. I have listed 5 project codes on the totals sheet and in week 1 I've entered those 5 codes and have allocated 2 hours to each project. The totals sheet is showing a total of 2 hours against of the projects - so far so good. If I enter "3:00" into the "Hours allocated" column for each row my "Hours remaining" column shows "1:00" against each project. Similarly, if I allocate 1 hour then the formula in the "Hours remaining column shows "Job over by 1 hours". Perfect. The problem arises when the hours allocated and the hours worked are the same. In this example when I enter "2:00" into the "Hours allocated" column some of the rows show "0:00" (which is what I would expect" ) but some show "Job over by 0:00 hours"! I have checked and double checked and all the relevant cells have the same formulas and are formatted the same - what could be wrong? Just to test, in a spare column I entered the formula =IF(C3-F3, "yes", "no") - column C is Hour allocated and column F totals data from the weekly sheets. The rows which show "0:00" return "yes" to this formula and the rows which show "Job over by 0:00 hours" return "no". I really don't have a clue how to fix this so any help would be greatly received. Regards, Gavin Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769988
  - 15
    - Question regarding Dates I receive reports weekly and I am creating a receipt log. When I receive the report I enter the date I received it. My date has to be setup as d-mmm-yyyy. I create the year 2008 daily on another worksheet and name it Year2008. In each cell, C2:BB19, I have a list with every day of the year of 2008, "Year2008". I also have conditional formatting referring to cells C1:BB1, Weekly dates. If the dates from C2:BB19 don't match, then, if early the cell turns yellow, and if late the cell turns orange. In the event that within a report, not the day I received the report, but what is actually in the report gives me a late information, I want to select a special date, for instance, *d-mmm-yyyy, rather than d-mmm-yyyy. Therefore I can create another condition where if there is a "*" before the date then the cell will turn red. I want to add another 2008 year to my already 2008 year except with someway of refering to something late in the report i received, like the *. My problem is, as far as I know, I can't create a date that is recognized as *d-mmm-yyyy. This may be as easy as creating another d-mmm-yyyy for 2008 and then inserting the *. But, I don't know how. Help? Thank you. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769981
  - 16
    - Formula will not work I typed the following formula in and is displays the formula in the cell just as it was typed in instead of calculating the formula. =COUNTIF(C8:Q8,"=''") Those are two single quotes after the equal sign. What do I need to change or check? Les Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769980
  - 17
    - Table Look Up I am trying to calculate a commission % based on a gross profit % range. So I have 8 rows of % ranges with 3 columns, column 1 is greater than and column 2 is less than, the third column has the commission %. Can someone tell me how to have a formula look at the table and tell me which % should be used for the calculation? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769973
  - 18
    - I need the correct function or formula... How do you have your spreadsheet automatically update the total amount when changing values... ..example amount ordered price total 2 1.99 3.98 Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769971
  - 19
    - linking worksheets I have a few spread sheet for sales reps that need to be linked to the main spread sheet. Can I link the spread sheets to where when I update the main one it will automatically update the others? Also, is there a way to copy the format of the main sheet (including formulas & cell widths) to new sheets? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769969
  - 20
    - Drop Down Boxes I am trying to create a questionaire with drop down menus to choose different answers. I have the drop down menu but I am not sure how to enter the text in it that I want to give as answer options? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769964
  - 21
    - blank lines in text cells I'm getting blank lines at the tops of text cells. Column widths are fixed and row heights are set to AutoFit. Cell alignment is set to Wrap text. What am I missing? Simple spreadsheet to track time spent on a project. First column is date, second column is verbal description of work done, and third column indicates hours spent on those tasks on that day. First and third columns are always one line and set for Top vertical alignment. Second column is typically several lines and is the one giving me problems. Changing from the default Bottom vertical alignment to Top has no effect. Solutions will be greatly appreciated. Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769960
  - 22
    - Translate from Numbers to Descriptions Each month many of us receive an auto-export in Excel that contains data that we use to create charts and Pivot Tables from. One of the columns contains numbers that reference a description that is not stored on the database that contains the export. We receive about 1000 records and what I have been doing is performing a Search and Replace but now there are 100 descriptions! I used to work with VLookup but was wondering if anyone has done something like this with a macro as well. I have Excel 2003 Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769956
  - 23
    - only want certain answers allowed to be entered in a cell I have Excel 2003 Is there a way to only allow certain answers to be entered in a cell? I only want them to be able to enter either Yes, No Or N/A (case doesn't matter). How can I do this? Thanks! Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769952
  - 24
    - How do I change default symbols in Excel 2007? Whenever I type (C) in Excel 2007, it defaults to the copyright symbol Â©. How do I stop the program from doing this, and to allow me to choose when I want to insert that or any other symbol instead of the program inserting it by default? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769951
  - 25
    - I'm unable to unhide rows 1-3 in Excel Rows 1 through 3 are hidden on a worksheet. I followed the directions to unhide rows, but it's not working. What can I do? Tag: Not Enough Memory opening 2nd spreadsheet Tag: 769950

I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the
other I get "Not Enough Memory". However my C: has 63.6 GB of avialable
memory. Why is this happening and how can I overcome this. Using Office 2000
on Windows XP.

--
Regards
Pete

Top

RE: Not Enough Memory opening 2nd spreadsheet by James_Thomlinson

James_Thomlinson
Fri Mar 14 10:49:03 CDT 2008

Check out this link...
http://www.decisionmodels.com/memlimits.htm
--
HTH...

Jim Thomlinson

"Pete Harris" wrote:

> I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the
> other I get "Not Enough Memory". However my C: has 63.6 GB of avialable
> memory. Why is this happening and how can I overcome this. Using Office 2000
> on Windows XP.
>
> --
> Regards
> Pete

Top

Re: Not Enough Memory opening 2nd spreadsheet by Bob

Bob
Fri Mar 14 11:03:59 CDT 2008

No, your HARD DRIVE has 63.6 GB of available storage. That has nothing
to do with your computers available memory.

Pete Harris wrote:

> I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the
> other I get "Not Enough Memory". However my C: has 63.6 GB of avialable
> memory. Why is this happening and how can I overcome this. Using Office 2000
> on Windows XP.
>

Top