Attachments for spreadsheet rows

Posted on 2014-03-17
Last Modified: 2014-03-20
We are creating an expense report in excel to be viewable and editable in the browser for SharePoint online Office 365. Each expense item is in a row. We would also like to be able to add an attachment to that row or item that is the scanned receipt. Can that be done in excel or would we have to use infopath?
Question by:BobHavertyComh
  • 2
  • 2
LVL 32

Expert Comment

by:Rob Henson
ID: 39934257
Assuming the scanned receipt is saved in the SharePoint as well, you can add a hyperlink to the file address.

Rob H

Author Comment

ID: 39934365
That's not really what we are looking for. For example, in Infopath, we can have a repeating table to hold each individual expense item and in the last column of each item, we have an attachment control where they can upload their scanned receipt that relates to that item. Can we do anything like that in excel? And if not, would the user have to first upload the scan to a SharePoint Picture Library and then manually enter a link to this on the spreadsheet in the expense report library? That kind of sounds like asking for trouble. I guess what I need and am looking for is some sort of attachment control that can be inserted into excel cells, but it doesn't look like it will let me do that.
LVL 32

Accepted Solution

Rob Henson earned 500 total points
ID: 39934441
As far as I know, you don't have the option to physically attach an item to an excel sheet which is why I suggested using a hyperlink.

You could maybe embed the item into the excel sheet and have it show as an icon but I suspect that would eventually make the file extremely large.

Rob H

Author Closing Comment

ID: 39934747
OK thanks. Just wanted to make sure I wasn't missing a capability.

Expert Comment

by:Sushanta Sahu
ID: 39941908
An excel itself is a file and can not hold another file within SharePoint. However to simplify this, you can import the spreadhseet to SharePoint as a list and then attach the scanned copies to their respective rows.

In this way you have to take the initial pain of adding the attachments. But in long run you will be relaxed as the list itself will be holding the data which you were planning to do on excel. For better results open the list in Datasheet view so that you get an Excel like view.

Let me know how it goes.

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Find out what the Office 365 disclaimer function is, why you would use it and its limited ability to create Office 365 signatures.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now