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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 33

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 33

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In a previous video Micro Tutorial here at Experts Exchange (, I explained how to get a free, one-month trial of Office …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

733 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