Linked excel (1 Viewer)

Gismo

Registered User.
Local time
Today, 23:45
Joined
Jun 12, 2017
Messages
1,298
Hi All,

I have a excel spreadsheet with comments. unfortunately the spreadsheet is so complex, i can not insert columns to display all the comments as this would duplicate the amount of columns i have.

is it possible to link the spreadsheet to access and have access display all the comments without creating the extra fields with the getcomments formula?
 

Ranman256

Well-known member
Local time
Today, 17:45
Joined
Apr 9, 2015
Messages
4,339
if the comments are in a cell, yes access can see.

if the comments are in the excel 'comment' object (with the red dot) then no, access cant show it.
you could run vb code to extract the comment object and place in a cell, but it may be impractical.
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:45
Joined
Sep 21, 2011
Messages
14,047
Could you use a whole new workbook as the location for the formula getcomments() ? match cell for cell?



Hi All,

I have a excel spreadsheet with comments. unfortunately the spreadsheet is so complex, i can not insert columns to display all the comments as this would duplicate the amount of columns i have.

is it possible to link the spreadsheet to access and have access display all the comments without creating the extra fields with the getcomments formula?
 

Users who are viewing this thread

Top Bottom