98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003
Excel 2003
Resolved · Low Priority · Version 2003
Wed 14 Jan 2009, 16:41Delegate Michelle said...
Michelle has attended:
Excel Introduction course
Excel 2003
I'm having difficulty understanding how to copy tables with formulas from one document to another or from a master without losing the formulas. i.e. Opening a master, changing data over three or four sheets, adding, removing columns etc and then the forumlas not working. Help !
Thu 22 Jan 2009, 10:56Trainer Amanda said...
RE: Excel 2003
Hello Michelle
Thank you for your question and welcome to the forum.
I'm assuming there are links between the data as you are working over multiple sheets and files.
When you paste data from one sheet to another, then you might find you have errors come up with the formulas when there are links in place.
Try using Edit - Paste Special and clicking the Paste Link button in the bottom left corner when pasting formulas from one sheet to another and see if this helps.
We do cover working with multiple worksheets and linking on our Excel Intermediate course.
Kind regards
Amanda
Wed 28 Jan 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use the Ctrl-key for quick navigation in Excel 2010If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key. |
