Paste Special Link _Excel 2003

[Lin]

Hi,
I try to paste a link from Access to excel and it keep give me errors with
the data. The data which I copying from Access displaying " #NAme?" with the
same number of colums and raws.

Also the link specify the only the database name automatically such as
=Msaccess|'C:\Database\SR.mdb'! not specifying tthe query name. I added the
query name to the link still doing the same.

Anyone knows why. Any help really appreciated

Thanks

 

[Sheeloo]

Looks like the = sign in fron of your links is giving you trouble. Excel is
interpreting it as a formula.

To test put a ' before the = sign in one of the cells and see what happens.

 

[Sheeloo]

The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will
either need to customise the Quick Access Toolbar to add the button
'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' or 'All
Commands' category, or alternatively you can use the Excel 2003 keyboard
shortcut sequence Alt-D-P to launch the wizard.
Source:
http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=172488&d=1025&dateformat=%o-%B

 

[Sheeloo]

Posted here by mistake.

The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will
either need to customise the Quick Access Toolbar to add the button
'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' or 'All
Commands' category, or alternatively you can use the Excel 2003 keyboard
shortcut sequence Alt-D-P to launch the wizard.
Source:
http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=172488&d=1025&dateformat=%o-%B