ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with Autoshape

Tue
Apr 21
2009

Excel 2007: Autoshapes dislocated on printing?

I have a 2003 excel file which has many arrows (autoshapes)... once we upgraded to office 2007, these arrows appear bit moved (dislocated) when printing or previewing. Tried file xls and tried to upgrade it to xlsx and still the same problem when opening in Excel 2007. Any idea why this is happening? is it a bug of compatiibiltiy between Excel 2007 and Excel 2003?
why?


Answer

Mostly yes, it is a bug

I would recommend to open that file in Excel2003 and group these objects then save the file and use it in Excel2007

Also, try the following:
1- Install the same printer you were using in Excel2003 and make it default
2- Do some cleaning to your computer (Follow these steps http://answers.yahoo.com/question/index?…
3- Make sure you have the Print scale to 100%



VBAXLMan

Tuesday 4/21/2009 7:22:25 AM

Tags

History