#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default Inserting columns

My Excel 2007 spreadsheet has 3 columns and 700,000 rows.
Why is it taking MANY HOURS to insert 4 new columns between columns B
and C?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default Inserting columns

Do you have volatile formulas in some of those rows

--


Regards,


Peo Sjoblom

"GARY" wrote in message
...
My Excel 2007 spreadsheet has 3 columns and 700,000 rows.
Why is it taking MANY HOURS to insert 4 new columns between columns B
and C?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default Inserting columns

On Aug 13, 8:13*am, "Peo Sjoblom" wrote:
Do you have volatile formulas in some of those rows

--

Regards,

Peo Sjoblom


No. I've already highlighted the 3 columns then I've done COPY/PASTE
SPECIAL/VALUES..
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB EXCEL INSERTING COLUMNS moosedog2000 Excel Discussion (Misc queries) 2 July 25th 07 09:40 PM
inserting new columns CJ Excel Discussion (Misc queries) 5 September 16th 06 07:18 PM
Inserting columns into a row park Excel Discussion (Misc queries) 1 August 2nd 05 10:09 PM
inserting columns within certain rows only crimsonkng Excel Discussion (Misc queries) 4 July 14th 05 05:13 PM
Inserting Columns GJB Excel Worksheet Functions 1 January 20th 05 03:41 AM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"