Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH
This file is found he http://uptonroadpress.com/music/
This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH
Hi
Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH
Thank you for your response. Yea, did that.
I have posted a new WB: http://uptonroadpress.com/music/ other costs building 0609 c test 2c.xls I have localized the issue. It is the AND part of the formula. I split the WB into 3 files. The AND comparison is very slow, and creates unreadable files when copied many times at once.. I replaced the AND with a double IF. Same result. The and determines if 1 number is between 2 others. The new example has the AND and the IF formulas: =IF(AND(AF$7=$O15,AF$7<=$P15),1,0) =IF(AF$7=$O32,IF(AF$7<=$P32,1,0),0) The challenge is to copy the formulas in column AF for the remaining column headers. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHH
just a shot in the dark, try using
=--AND(AF$7=$O15,AF$7<=$P15) and =--AND(AF$7=$O32,AF$7<=$P32) "J" wrote: Thank you for your response. Yea, did that. I have posted a new WB: http://uptonroadpress.com/music/ other costs building 0609 c test 2c.xls I have localized the issue. It is the AND part of the formula. I split the WB into 3 files. The AND comparison is very slow, and creates unreadable files when copied many times at once.. I replaced the AND with a double IF. Same result. The and determines if 1 number is between 2 others. The new example has the AND and the IF formulas: =IF(AND(AF$7=$O15,AF$7<=$P15),1,0) =IF(AF$7=$O32,IF(AF$7<=$P32,1,0),0) The challenge is to copy the formulas in column AF for the remaining column headers. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHH
Thank you for the resply.
Tried this: AND(AF$7=$O15,AF$7<=$P15) still slow Tried this: =--AND(AF$7=$O15,AF$7<=$P15) Excrutiatingly slower. How could such a simple function be such a drag? and =--AND(AF$7=$O32,AF$7<=$P32) "J" wrote: Thank you for your response. Yea, did that. I have posted a new WB: http://uptonroadpress.com/music/ other costs building 0609 c test 2c.xls I have localized the issue. It is the AND part of the formula. I split the WB into 3 files. The AND comparison is very slow, and creates unreadable files when copied many times at once.. I replaced the AND with a double IF. Same result. The and determines if 1 number is between 2 others. The new example has the AND and the IF formulas: =IF(AND(AF$7=$O15,AF$7<=$P15),1,0) =IF(AF$7=$O32,IF(AF$7<=$P32,1,0),0) The challenge is to copy the formulas in column AF for the remaining column headers. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHH
Hi
Your worksheet is corrupted somehow. I copied the block of data A1:AE42 and to a new workbook did Paste SpecialFormats followed by Paste SpecialFormulas I then did the same thing with range AF1:AF42 Then, copying the formulae from column AF in the new book through to column CY is almost instantaneous. After the new book is saved, file size comes tumbling down from 2089 KB to 74KB!! -- Regards Roger Govier "J" wrote in message ... Thank you for the resply. Tried this: AND(AF$7=$O15,AF$7<=$P15) still slow Tried this: =--AND(AF$7=$O15,AF$7<=$P15) Excrutiatingly slower. How could such a simple function be such a drag? and =--AND(AF$7=$O32,AF$7<=$P32) "J" wrote: Thank you for your response. Yea, did that. I have posted a new WB: http://uptonroadpress.com/music/ other costs building 0609 c test 2c.xls I have localized the issue. It is the AND part of the formula. I split the WB into 3 files. The AND comparison is very slow, and creates unreadable files when copied many times at once.. I replaced the AND with a double IF. Same result. The and determines if 1 number is between 2 others. The new example has the AND and the IF formulas: =IF(AND(AF$7=$O15,AF$7<=$P15),1,0) =IF(AF$7=$O32,IF(AF$7<=$P32,1,0),0) The challenge is to copy the formulas in column AF for the remaining column headers. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I cannot copy the columns of formulas in this Workbook::: AHHH
Thank you for your confirmation. I test a fresh sheet just now. Same result
as you. Does paste special formats/formula remove background debris from the cells? I had used COPY/Paste to get the header from the main SS. Maybe the problem is embedded in that part of the sheet. Thank you for your help. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Your worksheet is corrupted somehow. I copied the block of data A1:AE42 and to a new workbook did Paste SpecialFormats followed by Paste SpecialFormulas I then did the same thing with range AF1:AF42 Then, copying the formulae from column AF in the new book through to column CY is almost instantaneous. After the new book is saved, file size comes tumbling down from 2089 KB to 74KB!! -- Regards Roger Govier "J" wrote in message ... Thank you for the resply. Tried this: AND(AF$7=$O15,AF$7<=$P15) still slow Tried this: =--AND(AF$7=$O15,AF$7<=$P15) Excrutiatingly slower. How could such a simple function be such a drag? and =--AND(AF$7=$O32,AF$7<=$P32) "J" wrote: Thank you for your response. Yea, did that. I have posted a new WB: http://uptonroadpress.com/music/ other costs building 0609 c test 2c.xls I have localized the issue. It is the AND part of the formula. I split the WB into 3 files. The AND comparison is very slow, and creates unreadable files when copied many times at once.. I replaced the AND with a double IF. Same result. The and determines if 1 number is between 2 others. The new example has the AND and the IF formulas: =IF(AND(AF$7=$O15,AF$7<=$P15),1,0) =IF(AF$7=$O32,IF(AF$7<=$P32,1,0),0) The challenge is to copy the formulas in column AF for the remaining column headers. J "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Try changing your calculation mode before doing the copying XL2003 ToolsOptionsCalculationManual XL2007 Formulas tabCalculationCalculation OptionsManual Switch back to automatic when you have finished your copying. -- Regards Roger Govier "J" wrote in message ... This file is found he http://uptonroadpress.com/music/ This is making me crazy. I want to finish this workbook in my lifetime. I need to copy the formula cells to fill 72 columns. I have to copy about 1 percent of the formulas and paste to 4 columns each time to avoid a damaged sheet. I then save, and then close, and then open. Often the sheet is corrupted. Then I open the previous worksheet and try again. I have tried 2003 and 2007. 2007 takes 2-3 times to load, copy, save, and scrolling is torture. Thinking the sheet had a fundamental error I created a new workbook and copied the non-formula parts and used formulas saved in notepad files. I have used 2 computers: 1st uses vista, 2 gig cpu, 2 gig ram, The 2nd is a dual-core 2.4 gig cpu with 2 gig ram, xp sp3. Very few programs loaded, no AV, etc.,.... This is very annoying. This page is from a larger workbook that has 6 other pages with 72 columns of formulas. The others are not quite as complicated. But the workbook loads quicker than this one page workbook. Help me Rhoda, Help, Help me Rhoda J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COpy formulas from one workbook to another workbook | Excel Discussion (Misc queries) | |||
copy formulas to another workbook | Excel Discussion (Misc queries) | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
how do I copy a worksheet with formulas to another workbook? | Excel Worksheet Functions | |||
How to copy formulas from one workbook to another | Excel Discussion (Misc queries) |