Copying a worksheet to a new worksheet and formula randomly not staying in tact
I searched and could not find this answer though it seems like it would be a common question. So, if it already exists I am sorry-I couldn't find it. I am trying to copy a whole worksheet which contains formatting and formulas into a whole new worksheet. I did it with one and the formulas still calculate-but when I did it again to another worksheet the formulas stop calculating. Any ideas what I may be doing wrong?
Thanks!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Does the worksheet have any Names defined? Check if Names exist using 'Name Manager' on the 'Formulas' tab. You can see if Names are being used in formulae by clicking 'Show Formulas' on the same tab - this will change all the cells on the worksheet to show the formulae in use - look for formulae containing things like =Sales*2 instead of =C5*2.
Names can either be file-wide (a scope of 'Workbook') or sheet-specific. The first means that you can refer to the Name from any sheet and it always refers to the same cell/range. The second can only be referred to from the sheet it's on - so you can have 'JanuaryTotal' on multiple sheets, for example.
Copying a worksheet with Names can sometimes do funny things to the scopes of Names, which will then affect your results.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you both! To the request to post a picture it wouldn't help because it is the calculations that aren't always transferring over so that cannot be captured except to show when it does vs. doesn't work but you won't know if I just simply typed the numbers into the other reply-I will check on that and see if that's it.
Thank you both! I appreciate your quick help
We DON'T want a picture. We would like to have a workbook with your problem so that we can work with it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks