up vote 2 down vote favorite
share [g+] share [fb]

I need to delete sheets from a workbook w/o breaking formula references; is there a way to do this via code or settings?

link|improve this question
1  
What do you want to happen instead of the references breaking? Your question doesn't give much to go on... – Tim Williams Oct 19 '11 at 19:02
feedback

migrated from stackoverflow.com Oct 21 '11 at 9:22

This question came from our site for professional and enthusiast programmers.

3 Answers

up vote 2 down vote

My free Mappit! addin available from http://www.experts-exchange.com/A_2613.html has as one of its outputs a map that shows worksheet relationships

You could use this to detect where the potential issues from sheet deletion may arise

enter image description here

link|improve this answer
Due to the nature of SO, you will get less downvoting if you host your module elsewhere ;) – mplungjan Oct 20 '11 at 20:00
1  
Hi Michel, that certainly hasn't been my experience here thus far, it's very much about solution competency not origin. Plus ive always found the excel topics (at any forum) tend to stay above the site v site debates. – brettdj Oct 20 '11 at 21:53
Great. It was however downvoted for some reason. I voted it back up. – mplungjan Oct 21 '11 at 5:43
well there you go - I must have missed the earlier downvote that you were referring to. Thanks for that – brettdj Oct 21 '11 at 11:13
feedback
up vote 0 down vote

If you are hard coding to a specific sheet that would be impossible. Are you implying you would like the dependency to be shifted to another sheet?

link|improve this answer
feedback
up vote 0 down vote

As stated above, cannot delete the sheet without breaking the reference. However here are some options depending on your circumstances:

  1. Copy/paste special:values to retain the result of the formula and delete the sheet.
  2. Hide the sheet and protect the workbook instead of deleting the sheet.
  3. Change the references to a sheet in another workbook.
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard