Forum Discussion
BobsYourUncle54
Nov 25, 2021Copper Contributor
How do I make a hyperlink follow a moved file?
Office 365: I have a very large extensive spreadsheet I created for keeping track of customers for my business. I enter essential details, and contract amounts, along with deposits and payments unti...
OliverBuckley
Nov 25, 2021Copper Contributor
To be honest, it looks to me like you are using the wrong tool here? I love Excel passionately and we can get it to do many things, but that doesn't make it the right tool. I think of the expression, "if the only tool you have is a hammer, every problem becomes a nail". You have a lot of updating going on here. There are many online platforms that are geared for this - I signed up for Monday.com lately which looks very appropriate but there are others. That may not be the answer you are looking for but I think it would be a better solution for you.
- BobsYourUncle54Nov 25, 2021Copper Contributor
OliverBuckleyThanks for the thoughts on that. I had actually considered Monday.com after my daughter suggested it to me. As the controller for a large construction company, that's what she uses.
For me it may be like using a sledgehammer to swat a fly. It is a bit pricey, having to pay every month to rent it. Using a spreadsheet is free, aside from my annual 365 subscription. We are not a huge company, but I am very detail oriented and like to be able to pull info at a moments notice rather than having to dig through a bunch of files to get it.
I appreciate everyones input, thanks.