copy formula problem

Hi all,
I have one WB and when i copy data to another WB it will not copy formulas.
I had it saved as a macro enabled WB but changed this back to normal as i was thinking that this could have been the problem...
It will copy to another sheet within the same WB ok
Does anyone know why this is happening?
Thanks
loopiloo

Thanks i did it like you said changing = to # and back again
The other option using paste link i cannot use because when i select paste special i get (see pic)2013-06-19_134426.jpg
I would like to find a more permanent solution as i will have more things to copy/paste to different WB's
Can anyone tell me why i am having this problem..?

Just realized there is another problem
When i copied pasted then changed = to # and back again... i did it to the same row so it would keep the row locations the same.
Ive just moved it to the top of the WS and the row numbers do not change??? (they do not have $)

Its not just that i need to copy quite a lot... i am concerned that i will have this problem constantly... i have ran the problem solver or whatever it is called from the installation disc and reset the pc several times.. i have just opened two completely new WB's and entered data with a formula into one and then copy pasted it to the second.. but it has the same result.. it will only paste the values and formats but no formulas
Has anyone had this problem... and what did you do to solve it..?

If you want to copy formulas between two instances of Excel, press Ctrl+` (<--that's the grave character, above the Tab key), select the cell(s) you want to copy formulas from and Copy, switch to second instance of Excel, select [upper-left] cell to paste into, right click and choose Paste Options|Match Destination Formatting. In first instance, press Ctrl+` again to switch back to normal display.

It sounds like what i want to do here is simply not possible in excel... i am just confused as i was convinced that i had done this more than once before... is it not possible in excel to simply copy paste between two different WB's???

Managed to do it with # and = method..
Its just i was sure that i have copy pasted into another WB before and the formulas were also copy pasted.
Regarding the range i don't know what happened there.. it seems to be ok now...
Thanks for all your help
loopiloo

Originally Posted by akhileshgs

Glad that we could help you. Please update the topic to solved if you got what you wanted

_____________________________________________

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Easier method is to go to the thread options bar just above the first post. Click on Thread Tools and select the bottom option. Should be "Mark this thread as solved..."