#1   Report Post  
Old June 19th 06, 12:27 PM posted to microsoft.public.excel.misc
SergioCorreiaMaputo
 
Posts: n/a
Default Unprotecting a Sheet

Hi,

I am trying to insert rows in a sheet that was setup by someone else. When i
try use the insert row function i get a message stating that excel cannot
insert a row because it wants to keep the integrity of the formulas. The
sheet itself is not protected and there are no macros that are running. How
would i 'unprotect' this sheet in order to insert new rows?

  #2   Report Post  
Old June 19th 06, 12:39 PM posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default Unprotecting a Sheet


sounds strange. Selecting all the cell entries below the point where
you want to insert the row, and drag everything down one row. ie
instead of inserting a row, move the data down one row.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553166

  #3   Report Post  
Old June 19th 06, 01:24 PM posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Unprotecting a Sheet

"SergioCorreiaMaputo" wrote:
I am trying to insert rows in a sheet that was setup by someone else. When i
try use the insert row function i get a message stating that excel cannot
insert a row because it wants to keep the integrity of the formulas. The
sheet itself is not protected and there are no macros that are running. How
would i 'unprotect' this sheet in order to insert new rows?


Another guess is that you're trying to insert a row either within a
multi-cell columnar array formula range itself, or where a multi-cell
columnar array formula exists elsewhere (in another col) which straddles the
row insert point.
[although the error msg should be: You cannot change part of an array <g]

Try selecting the entire row at the insert point
Press F5 Special Check "Formulas" OK
This selects all the formula cells in that row

Check out each formula cell in turn,
look out for any array formulas which are housed within curly braces { }.

Then select the array formula cell(s) in turn, press CTRL + "/"
This would select the entire array formula range(s)
(if the selected cell is within the array).

You would then need to press Delete
to clear the entire array formula before you can insert a row
(but I'm not sure you still want to do this though, as you would need to
re-instate all the array formulas cleared after you insert the row)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #4   Report Post  
Old June 20th 06, 10:56 AM posted to microsoft.public.excel.misc
SergioCorreiaMaputo
 
Posts: n/a
Default Unprotecting a Sheet

Thanks Mallcat that worked

"Mallycat" wrote:


sounds strange. Selecting all the cell entries below the point where
you want to insert the row, and drag everything down one row. ie
instead of inserting a row, move the data down one row.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553166




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
Daily Totals on a summary sheet Allewyn Excel Worksheet Functions 10 June 27th 06 04:47 PM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
lock tab in sheet 2 until cell in sheet one is completed john tempest Excel Worksheet Functions 7 November 24th 05 08:45 AM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 07:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017